Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 10199 Views
- I also Faced
- E-Mail Answers
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 is fact table? Explain the different kinds of facts.
What is lookup transformation?
What is the sql query overwrite in source qualifier in informatica
Difference between Data and Index Caches?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is olap (on-line analytical processing?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
have u done any performance tuning? how u ll do?
How many transformations can be used in mapplets.
What is a repository manager?
How can we use mapping variables in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
What do you mean by enterprise data warehousing?
How to extract sap data using informatica? What is abap? What are idocs?
How big was your fact table
