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
- 10595 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
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the tasks that can be performed using sq?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain what are the different versions of informatica?
what is Active lock explain
How can one identify whether mapping is correct or not without connecting session?
How can repository reports be accessed without sql or other transformations?
What is the Process to creating lookup transformation in informatica
where to store informatica rejected data?
update strategy transformation in informatica
can anyone suggest best free Talend data integration training online
whats the logic to load the lower level of granularity of data to fact table.
What is substr in informatica?
Explain in detail scd type 2 through mapping.
can u give example for factless fact table
