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
- 11915 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
Global and Local shortcuts. Advantages.
What you know about transaction control transformation?
What are the differences between oltp and olap?
What is the difference between a connected look up and unconnected lookup?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the types of schemas we have in data warehouse.
Explain pushdown optimization $pushdownconfig parameter - informatica
Can we create multiple integration service on single repository?
Describe expression transformation?
Is it possible to create multiple domains on a single Informatica server?
What is joiner change?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the difference between informatica 7.0 and 8.0?
What is meant by LDAP users?
