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
- 2999 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
How to load the data from a flat file into the target where the source flat file name changes daily?
While migrating the data from one environment to another environment how would you manage the connections?
Is it possible to revert a global repository to local one and why?
What do you mean incremental aggregation?
Define filter transformation?
Explain the mapping variable usage example in informatica
How to configure mapping in informatica?
How to update source definition?
Write the prerequisite tasks to achieve the session partition?
What is sequence generator transformation in informatica?
What is informatica? Why do we need it?
What is the benefit of partitioning a session?
Explain what are the different versions of informatica?
What is mapplet in informatica?
What is pmcmd command?
