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 |
Why do you use Mapping Parameter and mapping variable?
What are the different lookup cache(s)?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
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..!
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.
How to fix the etl bugs..Tell me the process?
What is facttable granularity?
what is the difference between static and dynamic
waht type of interface is used for testing the data in informatica
What are the components of the workflow manager?
without using emailtask how will send a mail from informatica?
Define Pmrep command?