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



There are 4 source files which contains same metadata create target that should display the file nam..

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

There are 4 source files which contains same metadata create target that should display the file nam..

Answer / ramakrishna

double click the source go to properties tab check the
"ADD CURRENT PROCESSED FILE NAME PORT"

Is This Answer Correct ?    2 Yes 0 No

There are 4 source files which contains same metadata create target that should display the file nam..

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

Post New Answer

More Informatica Interview Questions

Can we create two repositories on same database instance in oracle?

0 Answers  


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,


What is degenerated dimention table?

7 Answers   Patni,


What is meant by pre and post session shell command?

0 Answers  


What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,






How to generate sequence numbers using expression transformation?

0 Answers   Informatica,


How to fix the etl bugs..Tell me the process?

1 Answers   IBM,


Explain what are the different types of transformation available in informatica.

0 Answers  


what is Active lock explain

0 Answers   Satyam,


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.

4 Answers  


How will the document be delivered to me?

0 Answers  


what is bridge tables in informatica

1 Answers   CTS,


Categories