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
- 11710 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
What does reusable transformation mean?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How does a rank transform differ from aggregator transform functions max and min?
What is informatica metadata and where is it stored?
How can we improve session performance in aggregator transformation?
How to update a particular record in target with out running whole workflow?
According to his methodology what all you need before you build a datawarehouse
how to load rows into fact table in data warehouse
How to load the data from people soft hrm to people soft erm using informatica?
update strategy transformation in informatica
Under what condition selecting sorted input in aggregator may fail the session?
Describe an informatica powercenter?
Write the prerequisite tasks to achieve the session partition?
What is a sequence generator transformation?
What do you mean by worklet?
