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
- 9861 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 a filter transformation?
What is domain and gateway node?
How can we remove the duplicates from flat file source?
Explain incremental aggregation in informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How to extract sap data using informatica?
In which transformation you cannot drag ports into it?
Write the program through which the records can be updated?
What is workflow? What are the components of workflow manager?
What is target load order?
Where are the source flat files kept before running the session?
What does “tail –f” command do and what is its use as an Informatica admin.
What is rank transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
