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 / k gopi krishna
1. Define source
2. Define SQF
3. put union stage
in first group put col1 and col3
in 2nd group put col2 and col3
4 link it to output file
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are batches?
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the mapping parameters and mapping variables?
Describe an informatica powercenter?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
generate date / time dimension in informatica
What is the need of an ETL tool?
Explain the tuning lookup transformation - informatica
Can informatica load heterogeneous targets from heterogeneous sources?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the Process to creating lookup transformation in informatica
How can repository reports be accessed without sql or other transformations?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Did u used latest transformations of 8.6.0? for what?