In a scenario I have col1, col2, col3, under that 1,x,y, and
2,a,b and I want in this form col1, col2 and 1,x and 1,y and
2,a and 2,b, what is the procedure?
Answer Posted / roopanwita
There is a stage in Datastage,Pivot to do normalization.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is aggregate cache in aggregator transformation?
What is standalone command task?
What are the advantages of using informatica as an etl tool over teradata?
How to Create a folder using pmrep command?
Explain about cumulative Sum or moving sum?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
server hot-ws270 is connect to Repository B. What does it mean?
How to delete duplicate row using informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is the surrogate key?
What are the designer tools for creating transformations?
what is the size of u r source(like file or table)?
Enlist few areas or real-time situations where informatica is required.
How to generate sequence numbers using expression transformation?
What is substr in informatica?