I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.


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

Post New Answer

More Informatica Interview Questions

what is runtime variable?

3 Answers   TCS,


there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,


how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,


what are presession,postsession success and postsession failure commands ?

1 Answers  


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  






How to load relational source into file target?

3 Answers   IBM,


without using rank transformation how can we rank items by using some other transformations

2 Answers  


What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  


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  


why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,


Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,


how i will stop my workflow after 10 errors

2 Answers   HP,


Categories