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..
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
How is union transformation utilized?
What is complex mapping?
What is event and what are the tasks related to it?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is powercenter on grid?
Explain why we use partitioning the session in informatica?
What does update strategy mean, and what are the different option of it?
Explain the aggregator transformation?
What is joiner change?
what is the size of your data warehousing?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is mapplet in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How we can create indexes after completing the load process?