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
- 7699 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
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to create Target definition for flat files?
What is the scenario which compels informatica server to reject files?
What are the modules in Power Center
Scheduling properties,whats the default (sequential)
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Implementation methodology
Write the different tools in the workflow manager?
What is pmcmd command?
Under which circumstances, informatica server creates reject files?
What do you understand by SOA of Informatica?
What are the differences between source qualifier and joiner transformation?
What is a passive transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
