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 differs when we choose the sorted input for aggregator transformation?
COM components can be used in Informatica
How do you convert single row from source into three rows into target?
What is the reusable transformation?
Explain lookup transformation source types in informatica
What is sequence generator transformation in informatica?
How do you take back up of repository?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the types of caches in lookup?
How can you generate reports in informatica?
What is union transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
tell me the rules and responsblites in our project(my project is development)
Briefly describe lookup transformation?
Differences between version 7.x and 8.x.