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
- 11911 Views
- iGate, I also Faced
- E-Mail Answers
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
Can we get 1st record through Informatica(without sequence number).
What does refresh system mean, and what are its distinctive choice?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is mapping debugger?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How is union transformation utilized?
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.
How many ways a relational source definition can be updated and what are they?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is depict expression change?
What is the difference between source qualifier transformations source filter to filter transformation?
How to do the error handling of if ur source is flatfiles?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Which transformation should we use to normalise the COBOL and relational sources?
What is a stored procedure transformation?
