Input flatfile1 has 5 columns, faltfile2 has 3 columns(no
common column)
output should contain merged data(8 columns)
Please let me know how to achieve ??
- 3 Answers
- 6572 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sukanta
As per your question two files have same no of records
take first file's 5 column to a expression
transformation,add a output column in it let say 'A'.create
a mapping variable let say 'countA' having datatype
integer.Now in port 'A' you put expression like
setcountvariable(countA).
take second file's 3 column to a expression transformation
,add a output column in it let say 'B'.create a mapping
variable let say 'countB' having datatype integer.Now in
port 'B' you put expression like setcountvariable(countB).
The above two is only meant for creating common fields with
common data in two pipeline.
Now join two pipe line in a joiner transformation upon the
condition A=B.
Now join the required 8 ports to the target.
You get your target as per your requirement.
Regards
Sukanta
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / moorthy g
You Can create dummy port for each source Qual. then connect
to Join Trans., and Join two dummy port.in Joiner
Transformation.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / moorthy g
You Can Use Union Transformation for combine two flat files
| Is This Answer Correct ? | 1 Yes | 14 No |
Using Connected or unconnected lookup for performance wise which one is preferable?.
I want load the data into target with out 1st and last record.
What is the difference between Active and Passive transformation?
What is domain and gateway node?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
What is Index Caches size?
what is scd?
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 basic needs to join two sources in a source qualifier?
If we set dd_insert in mapping and Delete in session properties what will happen.?
differences between service based and product based?
Teradata 
