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
- 7656 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
Why filter transformation is an active one?
What is data caches/ index caches?
Parameter and variable differences
What is a surrogate key?
How many ways are there to do 'remove duplicate records in informatica'?
What is parallel processing in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Define update strategy?
What do you mean by filter transformation?
What are the measure objects?
What is rank transformation?
How to create or import flat file definition in to the warehouse designer?
If informatica has its scheduler why using third party scheduler?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
