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
- 11938 Views
- iGate, I also Faced
- E-Mail Answers
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 update strategy transform?
What are the new features of informatica 9.x in developer level?
what are the deliverables?in your project?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How do you take back up of repository?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Performance tuning in UNIX for informatica mappings?
What is xml source qualifier transformation in informatica?
What is different between the data warehouse and data mart?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What do you mean by filter transformation?
What is standalone command task?
Explain the different lookup methods used in informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
