Interested to Buy Any Domain ? << Click Here >> for more details...
Lookup transformation, one condition is having SQL override
(Empno < 10) and the other condition is Lookup (Sal>1000),
which is dynamic. How will u resolve this situation?
- 1 Answers
- 3070 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sagar
Modify queries to include both in a single query as select* from EMP WHERE EMPNO<10 AND SALARY>1000;
OR
USE EXPRESSION TRANSFORMATION
REMOVE ALL SQL QUERIES AND SEND ALL RECORDS TO LOOKUP CACHE
USE EXPRESSION TRANSFORMATION BEFORE LOOKUP TO FILTER EMPNO<10 AND ADD LOOKUP TO COND SAL>1000 DYNAMICALLY
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the informatica performance improvement tips
How to join three sources using joiner? Explain though mapping flow.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
While migrating the data from one environment to another environment how would you manage the connections?
Where is metadata stored?
What are some examples of informatica etl programs?
How many input parameters can exist in an unconnected lookup?
What are the main issues while working with flat files as source and as targets ?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How can we use batches?
what is $$$$?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the use of transformation?
