When do you use sql override in a lookup transformation?


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

Post New Answer

More Informatica Interview Questions

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  


what is target update override and when we use it?

2 Answers   TCS,


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  


Enlist few areas or real-time situations where informatica is required.

0 Answers  


what is parallel querying and what r hints.

1 Answers  






What is aggregator transformation in informatica?

0 Answers  


what is unique constraint error ?

2 Answers   TCS,


How to view and Generate Metadata Reports?

1 Answers  


What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,


I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,


How to recover the standalone session?

2 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  


Categories