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 mapplet in informatica?
How to open an older version of an object in the workspace?
when informatica 8 series released ?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
what is incremental aggregation ,with example?
what is system requirement(SR) & business requirement(BR)?
What is the difference between warehouse key and surrogate key?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to recover sessions in concurrent batches?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What do you understand by term role-playing dimension?
how many ways can we implement SCD2?