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
- 9956 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 will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the issues you have faced in your project? How did you overcome those issues?
What is a node in Informatica?
What is informatica powercenter repository?
can u give example for factless fact table
Explain sessions and how many types of sessions are there?
What is informatica worklet?
Clarify the utilization of aggregator cache record?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain the types of transformations?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Mention few advantages of router transformation over filter transformation.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is blocking transformation?
