Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7822 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
What are multi-group transformations?
Which transformation is needed while using the Cobol sources as source definitions?
Partition, what happens if the specified key range is shorter and longer
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the different transaction levels available in transaction control transformation?
What is domain in terms of informatica?
What is transformation?
Performance tuning in UNIX for informatica mappings?
In which transformation you cannot drag ports into it?
What is the fact table?
can we override a native sql query within informatica? How do we do it?
How identifying bottlenecks in various components of informatica and resolving them?
How do you load only null records into target?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
