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
- 9800 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 the difference between informatica 7.0 and 8.0?
What is workflow manager?
What is standalone command task?
What is a pre-defined event and user-defined event?
How to extract sap data using informatica?
What is a passive transformation?
How to do unit testing in informatica? How to load data in informatica ?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What could be the possible resons of locks by user?
What is the difference between STOP and ABORT options in Workflow Monitor?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What does “tail –f” command do and what is its use as an Informatica admin.
Write the advantages of partitioning a session?
explain one complex mapping with logic? sales project?
Differences between version 7.x and 8.x.
