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
- 12075 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
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to load data in informatica ?
How to do the error handling of if ur source is flatfiles?
How do we call shell scripts from informatica?
without table how to come first record only in oracle?
What is joiner transformation?
how to load rows into fact table in data warehouse
how to load dimension table and fact table. plz tell me the steps.
How would you join a node to the already existing domain?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Write the unconnected lookup syntax and how to return more than one column.
What are the different versions of informatica?
What are some examples of informatica etl programs?
How can you increase the performance in joiner transformation?
