Here i am assuming that your single warehouse table has data from more th

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..

Question Posted / bidhar

5 Answers
11709 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

Please Help Members By Posting Answers For Below Questions

What is informatica powercenter repository?

1141

What is a standalone command task?

1134

can we override a native sql query within informatica? Where do we do it? How do we do it?

1012

What are the restrictions of union transformation?

976

Why sorter is an active transformation?

1130

What is a grid in Informatica?

999

Explain the pipeline partition with real time example?

1083

Where is metadata stored?

1042

How do you load alternate records into different tables through mapping flow?

1802

Explain the types of transformations?

1005

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2053

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1727

How might you approve all mappings in the archive all the while?

955

How to join three sources using joiner?

1028

What is main use of mapplet?

1070