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
- 11931 Views
- iGate, I also Faced
- E-Mail Answers
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 informatica?
what is INFORMATICA TESTING process
Target increases every day even though no new record was inserted
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
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 ?
What is the benefit of session partitioning?
Differentiate between source qualifier and filter transformation?
What you know about transaction control transformation?
What do think which one is the better joiner or look up?
Make a note of the quantity vaults made in informatica?
Why sorter is an active transformation?
How many transformations can be used in mapplets.
What is the use of an aggregator cache file?
What is main use of mapplet?
