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

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,


How many number of sessions that u can create in a batch?

3 Answers  


Differentiate between mapping parameter and mapping variable?

1 Answers  


what is the size of u r source(like file or table)?

0 Answers   HP,


Briefly describe lookup transformation?

0 Answers  


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,


design of staging area?

0 Answers  


What do you mean incremental aggregation?

0 Answers  


What are the Differences between connected and unconnected lookup?

6 Answers   TCS,


how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,


which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,


if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,


Categories