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 / amarnath
if u r using informatica 8.0 n above u have a option to
load the name of the file. this is in the sq itself just
check the currently processed file name box. remember this
will give u the complete path of the file, hence u need to
substring it before loading it to tgt
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is joiner transformation in informatica?
Enlist few areas or real-time situations where informatica is required.
Explain the types of transformations?
Differences between version 7.x and 8.x.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
how to load rows into fact table in data warehouse
What is a repository? And how to add it in an informatica client?
Why update strategy and union transformations are active?
What is rank transformation in informatica
What are some examples of informatica etl programs?
What are the different types of repositories created using informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the different lookup cache(s)?
What is blocking transformation?
What is the benefit of session partitioning?