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
- 10598 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
Explain target update override in informatica
Explain the pipeline partition with real time example?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Can we override a native sql query within informatica?
update strategy transformation in informatica
What are the popular informatica products?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How do you load only null records into target? Explain through mapping flow.
Write the different tools in the workflow manager?
tell me the rules and responsblites in our project(my project is development)
Scheduling properties,whats the default (sequential)
What is parallel processing in informatica?
How to generate sequence numbers without using the sequence generator transformation?
What is a node in Informatica?
What is lookup change?
