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
- 11711 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
whats the logic to load the lower level of granularity of data to fact table.
How do you manage the Parameter files while migrating your data from one environment to another environment?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to load the data from a flat file into the target where the source flat file name changes daily?
what is informatica metadata?
Differentiate between router and filter transformation?
What is an active transformation?
What's the layout of parameter file (what does a parameter file contain?)?
While migrating the data from one environment to another environment how would you manage the connections?
What do you mean by worklet?
How to differentiate between the active and passive transformations?
What are the prerequisite tasks to achieve the session partition?
What is the difference between router and filter?
difference between informatica 8.1.1 and 8.6
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
