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 to load last n records of file into target table - informatica
How to implement security measures using repository manager?
Quickly characterize reusable change?
Explain dynamic target flat file name generation in informatica
What is rank transformation?
What do you mean by enterprise data warehousing?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What do you mean by blocking transformation?
How you can differentiate between connected lookup and unconnected lookup?
r u done any partitions in ur project?
What is the format of informatica objects in a repository?
Differentiate between reusable transformation and mapplet.
Why do you use Mapping Parameter and mapping variable?
Under what condition selecting sorted input in aggregator may fail the session?
How we can create indexes after completing the loan process?