When will you use SQL override in a lookup transformation?
Answer / vanita
For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause
| Is This Answer Correct ? | 10 Yes | 0 No |
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
What is the term PIPELINE in informatica ?
When to use normalization transformation other than cobol source?
Why do you use Mapping Parameter and mapping variable?
Different qualification between a related rotate toward the sky and isolates look upward?
What is a parameter When and where do you them when does the value will be created
What does role playing dimension mean?
version controlling in informatica?
Using Expression transformation how to remove duplicate records from a relational source?
What is data merging, data cleansing and sampling?
Which is the t/r that builts only single cache memory?