When do you use sql override in a lookup transformation?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between normal and bulk loading? Which one is recommended?
what is target update override and when we use it?
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?
Enlist few areas or real-time situations where informatica is required.
what is parallel querying and what r hints.
What is aggregator transformation in informatica?
what is unique constraint error ?
How to view and Generate Metadata Reports?
What are teh different tasks that can be created in workflow manager?
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?
How to recover the standalone session?
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