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
Answers were Sorted based on User's Feedback
Answer / 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 |
double click the source go to properties tab check the
"ADD CURRENT PROCESSED FILE NAME PORT"
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prakash
A small correction of polimera.r.reddy@gmail.com.
'Add Currently Processed Flat File Name Port' option present
at source definition.
Is This Answer Correct ? | 0 Yes | 0 No |
Can we create two repositories on same database instance in oracle?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is degenerated dimention table?
What is meant by pre and post session shell command?
What is the difference between informatica 8.x and 9.x
How to generate sequence numbers using expression transformation?
How to fix the etl bugs..Tell me the process?
Explain what are the different types of transformation available in informatica.
what is Active lock explain
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
How will the document be delivered to me?
what is bridge tables in informatica