Explain one complecated mapping?

Answers were Sorted based on User's Feedback



Explain one complecated mapping? ..

Answer / rao

normalizer transformation.which will performs normalized data.
ex:year q1 q2 q3
2006 10 20 30
2007 20 30 40
after performing the normalizer transformation the date
will be like this
year item sales
2006 1 10
2006 2 20
2006 3 30
like 2007 also

Is This Answer Correct ?    1 Yes 1 No

Explain one complecated mapping? ..

Answer / informatica_learner

upstare,Rao
this only use one nomalizer transformation
configure one item as occurs 3 is ok
it is easy

Is This Answer Correct ?    0 Yes 0 No

Explain one complecated mapping? ..

Answer / ram kumar

SCD 2 is one of the complecated mapping in informatica

Is This Answer Correct ?    3 Yes 5 No

Post New Answer

More Informatica Interview Questions

Why do you use Mapping Parameter and mapping variable?

0 Answers  


What are the different lookup cache(s)?

0 Answers  


what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  


how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,


My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,






How to fix the etl bugs..Tell me the process?

1 Answers   IBM,


What is facttable granularity?

2 Answers  


what is the difference between static and dynamic

4 Answers   TCS, Wipro,


waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,


What are the components of the workflow manager?

0 Answers  


without using emailtask how will send a mail from informatica?

3 Answers  


Define Pmrep command?

0 Answers  


Categories