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
- 7537 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 meant by LDAP users?
Explain about Informatica server process that how it works relates to mapping variables?
How do you change a non-reusable transformation to reusable transformation?
How many transformations can be used in mapplets.
difference between repository database and repository service?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
what is the difference between informatica6.1 and infomatica7.1
What is data movement mode in Informatica and difference between them?
Target increases every day even though no new record was inserted
Where can we find the throughput option in informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What all are steps in up gradation of Informatica server?
Explain the code page compatibility?
Make a note of the quantity vaults made in informatica?
What is session task and command task?
