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

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  


following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,


What is a node in Informatica?

0 Answers  


How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  


how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,






How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,


What are the rank caches?

2 Answers   Informatica,


What are the types of maping in Getting Started Wizard?

1 Answers  


we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,


What is powercenter on grid?

0 Answers  


How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,


major difference between normal loading and bulk loading?

6 Answers  


Categories