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

Explain reference cursor?

1 Answers  


any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  


suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,


Why update strategy and union transformations are active? Explain with examples.

1 Answers  


What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,


How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,


I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,


Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1 Answers   TCS,


What is the default source option for update stratgey transformation?

1 Answers  


Could any one to tell Fact table Partitioning?

2 Answers  


how to remove staging area

1 Answers  


Categories