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 fact table? Explain the different kinds of facts.
What is rank index in rank transformation?
What is the use of transformation?
What are the uses of etl tools?
What is an aggregator transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Differentiate between reusable transformation and mapplet.
What are batches?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Explain the informatica workflow?
Define the various join types of joiner transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Explain the different kinds of facts.
Explain sessions. Explain how batches are used to combine executions?