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
- 11945 Views
- iGate, I also Faced
- E-Mail Answers
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
Why do we need informatica?
How do you load unique records into one target table and duplicate records into a different target table?
What is union transformation?
How to use procedural logic inside infromatica?
How would you join a node to the already existing domain?
How do you update the records with or without using update strategy?
Define sessions in informatica etl?
Describe data concatenation?
Explain lookup transformation in informatica
How many numbers of sessions can one group in batches?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain Dataware house architecture .how data flow from intial to end?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are different types of transformations available in informatica?
What is the difference between a connected look up and unconnected lookup?
