How to load the name of the current processing flat file along with the data into the target using informatica mapping?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  


What is confirmed dimension?

3 Answers  


After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  


Explain one complecated mapping?

3 Answers   Fidelity, Wipro,


HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,






If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,


I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  


what is data driven?

5 Answers   TCS, Wipro,


How union transformation is active ?

2 Answers   Puma,


checkout and checkin in informatica 8.6

3 Answers   TCS,


How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,


can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  


Categories