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 / arnab
create a system where you can identify a source with an
ID.you may call it as datasource_num_id , build a cross
reference table to store all tis information , in the map
you can use this cross reference table to get the ID and
populate this id in ur target table
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the maplet?
Explain your project of banking domian.
What do you understand by SOA of Informatica?
I have a flat file, want to reverse the contents of the flat file
What is workflow? What are the components of workflow manager?
complex mapping ur project u r invlve can u explain and give real time example give me ?
what is the size of your data warehousing?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
On which transformations you created partitions in your project?
waht type of interface is used for testing the data in informatica
Parameter and variable differences
What do you understand by a term domain?
How identifying bottlenecks in various components of informatica and resolving them?
what is INFORMATICA TESTING process
Explain in detail about scd type 1 through mapping.