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
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Slowly changing dimensions, types and where will you use them
Explain sql transformation in script mode examples in informatica
What is the benefit of partitioning a session?
How to implement security measures using repository manager?
How we can use union transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What do you mean by channel change?
what is the Default Source Option For Update Strategy Transformation?
What are ETL Tools?
define galaxy repository in informatica
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the procedure for creating independent data marts from informatica 7.1?
What is sequence generator transformation in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?