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

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,


Explain the types of transformations?

0 Answers  


Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,


There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,


How can informatica be used for an organization?

0 Answers  






I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  


What are active and passive transformations?

0 Answers   Informatica,


in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,


How to display null values on a target & non-null values on a target?

3 Answers  


how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,


write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,


what is data driven?

1 Answers  


Categories