hi,there is a scenario like.
there are three columns empid,salmonth, sal contains the values 101,jan,1000
101 feb 1000 like twelve rows are there then my required out put is like
contains 13 columns empid jan feb marc.......dec and the velues are
101 1000 1000 1000 like this . thank you
Answer Posted / anoymous
I think this reverse Data pivoting,
may be Normalizer T/r will use to achieve to target am not
sure..
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is sq transformation?
What are data-driven sessions?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Performance tuning in UNIX for informatica mappings?
Is there any way to read the ms excel datas directly into informatica?
What are the databases that informatica can connect to windows?
Explain load alternative records / rows into multiple targets - informatica
What does cheating measurement mean?
Can you use flat files in Mapplets.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the reusable transformations?
What is difference between a gateway node and worker node?
What are the differences between joiner transformation and source qualifier transformation?
How does a sorter cache works?
What will be the approach?