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
- 10597 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / arnab
create a system where you can identify a source with an
ID.you may call it as datasource_num_id , build a cross
reference table to store all tis information , in the map
you can use this cross reference table to get the ID and
populate this id in ur target table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to join three sources using joiner? Explain though mapping flow.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
explain about unit testing? in real time?
What are the designer tools for creating transformations?
how many types of dimensions are available in informatica?
What is rank transformation in informatica
What are the steps involved in the migration from older version to newer version of Informatica Server?
Mention few advantages of router transformation over filter transformation.
What is a rank transform?
What is Index Caches size?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Where are the source flat files kept before running the session?
What is rank transform?
Explain sessions and how many types of sessions are there?
whats the logic to load the lower level of granularity of data to fact table.
