There are 4 source files which contains same metadata create target that should display the file name along with record
please send answer with mapping
Answer Posted / polimera
create pass through mapping
src----> sq--->trg
in source qualifier , double click on it and select
properties tab
her select that "add currenttly proccesed file name"
and in target create one port kto store filename.
in session properties select that indirect method
for this you need to create one list file with all the 4
file paths
then it loads every record with its file name.
please guys if u have any queries let me know,
u can send ur queries to my mail id:
polimera.r.reddy@gmail.com
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is domain and gateway node?
Explain sessions?
How to create a non-reusable instance of reusable transformations?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the difference between writing a joiner query in ANSI style and THETA style?
What are some examples of informatica etl programs?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
write a query to retrieve the latest records from the table sorted by version(scd)
How to open an older version of an object in the workspace?
Design time, run time. If you don't create parameter what will happen
What is the difference between router and filter?
Briefly define reusable transformation?
Enlist the advantages of informatica.
What are the differences between oltp and olap?
How to call shell scripts from informatica?