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
- 11914 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 a filter transformation and why it is an active one?
r u done any partitions in ur project?
What is an aggregator transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
What you know about transaction control transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the use of an aggregator cache file?
What can we do to improve the performance of informatica aggregator transformation?
Partition, what happens if the specified key range is shorter and longer
where to store informatica rejected data? How to extract the informatica rejected data?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are pre and post-session shell commands?
what is the Default Source Option For Update Strategy Transformation?
What is depict expression change?
pmscmd startworkflow -sv
