When will you use SQL override in a lookup transformation?
Answer Posted / 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 |
Post New Answer View All Answers
explain about unit testing? in real time?
What are the limitations of joiner transformation?
How you prepared reports for OLAP?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
what is informatica metadata?
What are the restrictions of union transformation?
How many number of sessions can one group in batches?
Briefly explain the aggregator transformation?
How to partition the Session?
Can anyone tell me the new features in Informatica 9 Version?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Which version configuration tool used in ur project?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.