Sunday, March 30, 2008

Checklist for Informatica Mappings

Checklist for Informatica Mappings

INTRODUCTION

This document consolidates the checklists that can be used for projects that use Informatica as a ETL tool. Following are the Checklist that are provided as a part of the Document.

Contents:

S.No

Checklist

Description

1

Code Review Checklist

Checklist for performing a Code Review Activity on Informatica mapping on 6.2 Version

2

Test Review Checklist

Checklist for performing a Test Review Activity on Informatica mapping on 6.2 Version

3

Informatica Upgrades checklist

Checklist that elaborates the various points that needs to be taken care while doing a Informatica version upgrade from 5.2.1 to 6.2.

Project Overview

Code Review Checklist for Informatica Mappings

Mapping Name:

Location of Mapping:

Developer Name: Filled Date:

Reviewer Name: Filled Date:

1.1 GENERAL

S. No.

Checklist item

Developer

(Y/N)

Reviewer

(Y/N)

Remarks

1.

Check if the data type and length of ALL the mapped fields is consistent throughout the mapping (right from the Source across all the Transformations till the Target).

2

Check that all the components used in mapping are shortcuts, pointing to actual components.

3

Informatica doesn’t define keys automatically from database to source or target definitions. Check that primary keys are defined correctly.

4

Check that tracing level is selected as ‘normal’ in all the components used in the mapping.

5

Check that relevant description is entered for all the components used in the mapping.

6

Check that the usages of all the parameters/variables in the mapping are consistent.

7

Check that there is no hard coding in the mapping, unless specified in the design document.

8

Check naming convention of all the components in the mapping per standard guidelines.

9

Check that option ‘file list’ is checked in case of sessions reading from a file having list of xml file names.

10

Check if Error Handling is taken care wherever applicable.

11

Check if the logic in the mapping is in sync with the logic mentioned in the Detailed design.

12

If any hard coding is present in the mapping, ensure that it is in the proper case.

13

Removal of ‘output port’ option of the fields, which are just used in calculations and not linked further.

14

Keep minimum number of records from the master table in case of a joiner

15

Check if the session has been run at least once and the target was populated.

1.2 SOURCE QUALIFIER

S. No.

Checklist item

Developer

(Y/N)

Reviewer

(Y/N)

Remarks

1

Check if ALL the fields mapped from the Source Qualifier are linked properly across all the transformations till the Target

2

Use the source filter and user defined join in the source qualifier unless we have some specific conditions that are present in the SQL override which cannot be incorporated in these properties.

3

Deletion of links from Source Definition to Source Qualifier, which are not used from SQ.

4

Filter the unnecessary records at the source qualifier itself, like get only active records etc.

5

Instead of coding SQL in the override query, use GENERATE SQL option wherever possible. Check if all the override queries are valid (by using VALIDATE option).

1.3 EXPRESSION

S. No.

Checklist item

Developer

(Y/N)

Reviewer

(Y/N)

Remarks

1.

Check if Default values are provided for NUMERIC fields used in arithmetic (+, -, *, /) and Logic operations.

2.

Check if Default values are provided for CHARACTER / Date fields used in logic operations (eg. String Compare)

3.

Check if Default values are provided for fields Nullable from Source & NOT Null able in the Target

4

Check that default value is provided only in expression transformations. Ports should not be defaulted in transformations like router, aggregator or update strategy.

5

Check if leading and trailing spaces are trimmed in CHAR-VARCHAR comparisons.

6

Usage of DECODE function instead of successive IIF functions.

7

Usage of Operators instead of functions (eg. || Vs CONCAT)

1.4 LOOK-UP

S. No.

Checklist item

Developer

(Y/N)

Reviewer

(Y/N)

Remarks

1

While doing lookup on a table, check that the data types of the input ports in lookup and in expression are exactly same.

2

In the session of a mapping that has lookups, ensure that we have $Source or $Target in the Lookup Information column unless the lookup is neither from the source or target database.

3

Make all the Lookups in your mappings reusable. Check if a reusable lookup exists already. If yes, reuse the same lookup or else create a new reusable lookup.

4

Check if the table names in the lookups are qualified with the schema name.

5

Check if the mapping has more than one dynamic lookup on the same table with the same lookup condition. If so, split the mapping into two & use Normalizer in one of the mappings.

6

Removal of unused ports from Lookups and Source Qualifiers.

7

Try to avoid making lookups on Nullable fields it is slower.

1.5 AGGREGATOR

S. No.

Checklist item

Developer

(Y/N)

Reviewer

(Y/N)

Remarks

1

Try to use sorted inputs for Aggregator where ever applicable.

1.6 ROUTER

S. No.

Checklist item

Developer

(Y/N)

Reviewer

(Y/N)

Remarks

1

Check if you are populating more than one target tables. If yes, use router before the update strategy.

2

Usage of Router instead of multiple filter transformations.

1.7 UNIX COMPONENTS

S. No.

Checklist item

Developer

(Y/N)

Reviewer

(Y/N)

Remarks

1

Check that all the *.dat files containing Informatica session names have a blank line at the end.

2

Check that name of the sessions in *.dat files and in script are exactly same as the actual session names

3

Check that proper commenting is done in the scripts

4

Check if the mapping has multiple targets. Unix script cannot work for multiple targets. If possible, try splitting the mapping.

67 comments:

Unknown said...

I have read your blog, it was good to read & I am getting some useful info's through your blog keep sharing... Informatica is an ETL tools helps to transform your old business leads into new vision. Learn informatica training in Chennai from corporate professionals with very good experience in informatica tool.
Regards,

Informatica training in chennai|Best Informatica Training In Chennai|Informatica training center in Chennai|FITA Academy Chennai

Unknown said...

It is really a great and useful piece of info. I’m glad that you shared this helpful info with us. Please keep us informed like this. Thank you for sharing.

Android Training in Chennai

Jeffy said...

Superb i really enjoyed very much with this article here. Really its a amazing article i had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.
Digital Marketing Company in Chennnai

Padhma said...

I am expecting more interesting topics from you. And this was nice content and definitely it will be useful for many people.

Home Spa Services in Mumbai

Akshaysri said...

Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.
GRE coaching in chennai

Swethapriya said...


The way you have stated everything above is quite awesome. Keep blogging like this.you have done a great job I appreciate your effort and I hope you will get more positive comments from the web.




Laser Root Canal Treatment In Chennai

Unknown said...

This was so useful and informative. The article helped me to learn something new. iOS App Development Company in India

Unknown said...

This blog provides useful information about new techniques and concepts.very impressive lines are given which is very attractive.
IELTS Coaching Classes in Chennai

Unknown said...

Truly a very good article on how to handle the future technology. After reading your post,thanks for taking the time to discuss this, I feel happy about and I love learning more about this topic
Best Dental Clinic In Annanagar

Aashi siva said...

I do believe all of the concepts you’ve introduced in your post. They’re very convincing and will definitely work. Nonetheless, the posts are too short for novices. May you please extend them a bit from subsequent time? Thank you for the post.
Android Training in Chennai
CCNA Training in Chennai
Digital Marketing Training in Chennai

Aashi siva said...

I do believe all of the concepts you’ve introduced in your post. They’re very convincing and will definitely work. Nonetheless, the posts are too short for novices. May you please extend them a bit from subsequent time? Thank you for the post.
Android Training in Chennai
CCNA Training in Chennai
Digital Marketing Training in Chennai

Melina Mia said...

I’m really amazed with your posting skills as well as with the layout on your blog site. Is this a paid style or did you modify it yourself? Either way keep up the pleasant quality writing, it is rare to see a great site such as this one these days.
Delivery service singapore
Singapore delivery service
24 hour delivery singapore

Unknown said...

I’m really amazed with your posting skills as well as with the layout on your blog site. Is this a paid style or did you modify it yourself? Either way keep up the pleasant quality writing, it is rare to see a great site such as this one these days.
Digital

Marketing Company in Chennai

Pradeep said...

It's a nice blog keep on creating a blog like this :-)

Digital Marketing Training in Chennai


Java Training in Chennai


Web Designing Training in Chennai


Microsoft Azure Training in Chennai

Unknown said...

thanks for your sharing information.and very useful to me..keep your updates.

AWS Training in Chennai

Raghu said...

It's a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much.
Hyperpigmentation Treatment
Herbal Tonic

subuvenni said...
This comment has been removed by the author.
subuvenni said...

i really like this blog.And i got more information's from this blog.thanks for sharing!!!!
Iperidigi in chennai
SEO Company in Chennai
SEO Company in India

Unknown said...

It's a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much.

Allergy Medicines
Ayurvedic Medicine For Immunity
Hyperpigmentation cream
Viral Fever Medicines



Nicole Bolton said...

I do trust all of the concepts you’ve presented on your post. They’re really convincing and will definitely work. Still, the posts are too brief for newbies. May you please extend them a little from subsequent time?Also, I’ve shared your website in my social networks.
Logistics software
Logistics management software
Fleet Management Software
Warehouse Management Software
Logistic ERP
Transport ERP

Unknown said...

It's a wonderful post and very helpful Informatica Online Training

Unknown said...




This blog was very useful for me waiting for more blog.


SAP FICO Training in Chennai

Unknown said...

Thank you for sharing


Hadoop Training in Chennai

Ancy merina said...
This comment has been removed by the author.
Unknown said...

Thanks for sharing this valuable information...



VMware Training in Chennai

Unknown said...

Thanks for your valuable information...
SAP FICO Training in Chennai

Unknown said...

I got a lot of information from your blog. It is useful for me. Keep on sharing like this information...
SAP MM Training in Chennai

Unknown said...

Very interesting to read your blog. It make viewer to keep updated.

Selenium Training in Chennai

Unknown said...

Thank you.......nice and inspiring.....
Best Salesforce Training Institute

soumya said...

Thank you for sharing an inspiring blog for Informatica learners, keep share more content on Informatica Online Training

Unknown said...

Omrdeals.in is an online platform that
allows people to find offers and the greatest
deals in and around OMR. It is the directory
of the business in and around omr. It helps
internet users to surf the required deals and
offers.

Offers in OMR

Unknown said...


This is extremely helpful info!! Very good work. It is very interesting to learn and easy to

understood.
Android Training Institute in

chennai

Tejuteju said...

Thank you. Well it was the nice to post and very helpful information on Informatica Online Training

akash thakur said...

hello sir,
thanks for giving that type of information.Glass Laminated Doors suppliers in hubli

Unknown said...

Your site is amazing and your blogs are informative and knlowledgeble to my websites.This is one of the best tips in my life.I have in quite some time.Nicely written and great info.Thanks to share the more informations.

Seo Experts
Seo Company
Web Designing Company
Digital Marketing
Web Development Company
Apps Development

sachin.ogeninfo said...

lyrics with music
tu cheez lajawab

mathimathi said...

I have enjoyed this post very much.Thanks for sharing.
SEO Training in Chennai |
SEO Training |
SEO Course in Chennai

mathimathi said...

What a funny signboards. Keep sharing these kinds of signboards. Thanks for your funny name boards.
ccna Training in Chennai |
ccna course in Chennai |
ccna Training institute in Chennai

Antony Jack said...

Great post! I am actually getting ready to across this information, is very helpful my friend. Also great blog here with all of the valuable information you have. Keep up the good work you are doing here.Well, got a good knowledge.
Asset Management Software
Asset Tracking Software
Asset Management Software India

Unknown said...

Wonderful bloggers like yourself who would positively reply encouraged me to be more open and engaging in commenting.So know it's helpful.

Java training in Chennai | Java training institute in Chennai | Java course in Chennai

Java training in Bangalore | Java training in Electronic city

Java training in Bangalore | Java training in Marathahalli

Java training in Bangalore | Java training in Btm layout

sheela said...

Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.
Online DevOps Certification Course - Gangboard
Best Devops Training institute in Chennai

Unknown said...

Useful information.I am actual blessed to read this article.thanks for giving us this advantageous information.I acknowledge this post.and I would like bookmark this post.Thanks
Data Science course in Chennai | Best Data Science course in Chennai
Data science course in bangalore | Best Data Science course in Bangalore
Data science course in pune | Data Science Course institute in Pune
Data science online course | Online Data Science certification course-Gangboard
Data Science Interview questions and answers
Data Science Tutorial

Ultra Labs Keto said...

Tevida problems, negative side effects and even death.Be sure to include the name of the supplement. And, as much as possible, take a container with a supplement you are taking so that your doctor can evaluate
https://www.supplementsforfitness.com/tevida/

Aaditya said...

Wonderful Blog, great blog post that you have provided for peoples. Its really good. Nice information.


Data Science Bangalore

janitha said...

Really impressive post. I read it whole and going to share it with my social circules. I enjoyed your article and planning to rewrite it on my own blog.
machine learning course malaysia

Priyanka said...

Attend The Python training in bangalore From ExcelR. Practical Python training in bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Python training in bangalore.
python training in bangalore

data science analytics rakshi said...

I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page! digital marketing course in singapore

Bushraah88 said...

I was just browsing through the internet looking for some information and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject. Bookmarked this page, will come back for more.Data Science Courses

jaanu said...

Thanks for the nice blog. It was very useful for me. I'm happy I found this blog. Thank you for sharing with us,I too always learn something new from your post.
big data coursed

Nutra Mini said...

Control X Keto - I'm doing this for you so you won't have to. This is the exception this proves the rule. WhooHoo!! We will attempt to walk you through the process of purchasing your Weight Loss. If you have Weight Loss then you are Weight Loss crazy. I agreed to that at the time. Probably, my purpose is coming through alright. I'm not telling you all to run out and begin buying it. Your next step is chosing the occasion.

https://www.nutramini.com/control-x-keto-reviews/

https://www.nutramini.com/keto-go-fit/

http://latestreviews.over-blog.com/drone-xtreme-reviews/

http://nutragrow.over-blog.com/toxifort-thailand/

https://nutramini.blogspot.com/2019/12/control-x-keto-reviews.html

http://nutramini.over-blog.com/control-x-keto/

Bhanu sri said...

360DigiTMG has developed the Certification Program in Healthcare Analytics. This course is meticulously designed to suit both Healthcare practitioners, IT Business Analysts and Data Scientists.
https://360digitmg.com/india/life-sciences-and-healthcare-analytics-certification-programme

nisha said...

The Post is very Impressive. every content of this blog is Really impressive. each and every cont should be neatly represented.

Data Science Training Course In Chennai | Data Science Training Course In Anna Nagar | Data Science Training Course In OMR | Data Science Training Course In Porur | Data Science Training Course In Tambaram | Data Science Training Course In Velachery

devi said...

After seeing your article I want to say that the presentation is very good and also a well-written article with some very good information which is very useful for the readers....thanks for sharing it and do share more posts like this.

Data Science Training In Chennai

Data Science Online Training In Chennai

Data Science Training In Bangalore

Data Science Training In Hyderabad

Data Science Training In Coimbatore

Data Science Training

Data Science Online Training

Latest Reviews said...

In point of fact, Tech Gadgets is the answer to the question. You've just learned a lesson. It has been a top secret up until now, the tired old facts dealing with Tech Gadgets.. I thought I wasn't clear that I guess this is a bad viewpoint, but you might forget this theory. I think it has some newsworthiness yet everything I have done with Tech Gadgets has worked this well.


AOL Support Number
PowerVolt Energy Saver

Maneesha said...

It is imperative that we read blog post very carefully. I am already done it and find that this post is really amazing.
data scientist training and placement in hyderabad

CSS Founder said...

We are known as the best web design company in navi mumbai that have delivered many successful projects across the world. We can be the right choice for you. Connect with us for more information.

David Fincher said...

Mindblowing blog very useful thanks
Spoken English Classes in OMR
Spoken English Classes in Chennai

Unknown said...

such a nice post you write it very well i learnd lot of thing by your post.Projects in sector 79 Noida

Gaurav's Blog said...

Thank you so much for your valuable information, it help us to grow and learn things. So thank you so much again and keep up the good work
iPhone Insurance

Gaurav's Blog said...

Really amazing information, thanks for your efforts for this blog. Thank you so much for sharing this post
Tent Companies in UAE

CSS Founder said...

Thank you for your post. This is excellent information.
website designing company in Lucknow

PromoteDial - Prince Kumar said...

Connect with the best SEO Company in Mumbai that can provide you fully digital marketing solution at an affordable price. Connect with us for more information.

Unknown said...

Uncommonly in ordinary extraordinarily captivating post. I was looking for such an information and partook in the experience of examining this one. Keep on posting. A responsibility of appreciation is for sharing.data analytics course in bhubaneswar

sdfasdfsadfsdfs said...

Use CSS Founder's website price calculator and check your Website development cost free.

cssfoundergurgaon said...

You can choose CSS Founder company for your website design needs because this is the bestWebsite designing company in Noida and also helps your business to grow.

Vishal Tomar said...

Welcome to VisitsVisa, your trusted source for all things related to India visa applications. As one of the leading visa service providers, we understand the importance of a seamless and hassle-free visa application process. Whether you are traveling for business or leisure, obtaining an India visa is an essential step.

cssfoundergurgaon said...

To attract customers, a web design company in Pune should prioritize an attractive and user-friendly interface. The website should convey the brand identity intuitively using attractive graphics and intuitive navigation. Responsive design is important to ensure optimal performance across all devices. Including strategic calls-to-action and easy-to-find contact information increases user engagement.