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 / vdiwade
Yes its possible through above logic…In addition to Srinu
idea....you can understand very easy way. Suppose creare one
(specific src) insert script.. means for 500 sources,500
insert script,which loads data into one src/tgt…we can add
one more column source_name tht will be always coming
source_name..so at the time of retrieving we can easily
understand this records belongs which source/tgt tbl.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is the -ve test case in your project.
What are the types of data warehouses?
How to load last n records of file into target table - informatica
In warehouses how many schemas are there?
Enlist the differences between database and data warehouse.
How to do the error handling of if ur source is flatfiles?
What is a code page?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain the different lookup methods used in informatica?
Explain lookup transformation in informatica
What is flashback table ? Advance thanks
difference between repository database and repository service?
How to handle decimal places while importing a flatfile into informatica?
How will the document be delivered to me?
difference between informatica 8.1.1 and 8.6