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 is lookup change?
How you prepared reports for OLAP?
What is joiner transformation?
What do think which one is the better joiner or look up?
What is session task and command task?
Differences between connected and unconnected lookup?
explan ur project architecture?
What are the static cache and dynamic cache in informatica?
what is SDLC way of code development?
Explain sessions. Explain how batches are used to combine executions?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the advantages of informatica?
How to do the error handling of if ur source is flatfiles?
Briefly define reusable transformation?
What are pre and post-session shell commands?