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 / bidhar
Here i am assuming that your single warehouse table has
data from more than one source,and you need to distinguish
the data among the sources.
For this to accomplish you can have table which can have 2
columns Datasourcename and ID.This table will have all the
source list and ID column will be the surrogate key.
Now you need to alter your warehouse table by adding a new
column called Source Identifier.
Now you have the architecture ready.
When loading your warehouse table just look up the first
table for the source name and pickup the corresponding
surrogate key and populate into the Source identifier
column in the warehouse table.Use this Column(Source
Identifier)to identify the sources.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the different types of transformation available in informatica.
my source is junk data how will u remove that junk data by using unix please any one replay me
What is an unconnected transformation?
Explain sessions. Explain how batches are used to combine executions?
What is Data Caches size?
Explain direct and indirect flat file loading (source file type) - informatica
update strategy transformation in informatica
Why do we need informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How will the document be delivered to me?
What is decode in static cache?
What is the difference between stop and abort in informatica
How do you manage the Parameter files while migrating your data from one environment to another environment?
How many transformations can be used in mapplets.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records