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
- 11937 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
Implementation methodology
Differentiate between a database and data warehouse?
How are indexes created after completing the load process?
What do you understand by a term domain?
Write the unconnected lookup syntax?
Please let me know how to make Data masking in informatica..
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is informatica etl tool?
Define filter transformation?
What the difference is between a database, a data warehouse and a data mart?
What is powercenter on grid?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are mapplets? How is it different from a Reusable Transformation?
What are the databases that informatica can connect to windows?
Explain pushdown optimization $pushdownconfig parameter - informatica
