Interested to Buy Any Domain ? << Click Here >> for more details...
Please let me know how we can implement the below scenario.
In a single mapping,more than 500 sources
(legacy,VSAM,relational) will be loading into only one
target. Whenever I retreive the data(any record) from
target, i need to find the details that the record belongs
to which source.
Thanks in advance..
- 5 Answers
- 11916 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / srinu
Hi ,
After every Source qualifier transformation just keep an
Expression with flag.
Dont go Single Source qualifier trans.
Keep 1 source qualifier trans for one table.
Any corrections let me know ,,,,
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Differentiate between source qualifier and filter transformation?
What are pre and post-session shell commands?
Explain joiner transformation in informatica
Define Pmrep command?
What are session parameters ? How do you set them?
What is a code page?
Which transformation is needed while using the Cobol sources as source definitions?
What can we do to improve the performance of informatica aggregator transformation?
What will be the approach?
What is the way to execute pl/sql script using informatica mapping?
What is meant by query override?
Why update strategy and union transformations are active? Explain with examples.
What are the prerequisite tasks to achieve the session partition?
Define the various join types of joiner transformation?
