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
- 12074 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
permutations of mapplet
What is a filter transformation and why it is an active one?
What is transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to join three sources using joiner? Explain though mapping flow.
Where do we use mapping variables in informatica?
How do you load first and last records into target table?
What is the scenario which compels informatica server to reject files?
Differentiate between Load Manager and DTM?
What do you mean by worklet?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are pre and post-session shell commands?
Explain load alternative records / rows into multiple targets - informatica
Enlist few areas or real-time situations where informatica is required.
What is fact table? Explain the different kinds of facts.
