Explain one complecated mapping?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / ram kumar
SCD 2 is one of the complecated mapping in informatica
Is This Answer Correct ? | 3 Yes | 5 No |
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
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?
What is a node in Informatica?
How can you define a transformation? What are different types of transformations in Informatica?
how we can load rejected record's at run time?(not through bad files)
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?
What are the types of maping in Getting Started Wizard?
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?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
major difference between normal loading and bulk loading?