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 use of code page?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Explain your project of banking domian.
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
How can we use mapping variables in informatica? Where do we use them?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
can we use bulk loading when we use look in mapping
If informatica has its scheduler why using third party scheduler?
What is staging area?
What is transformation?
in realtime which situations u can use unconnected lookup transformation