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
- 3071 Views
- IBM, I also Faced
- E-Mail Answers
Answer / 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 |
Global and Local shortcuts. Advantages.
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
how to obtain performance data for individual transformations.
How can we update a record in the target table without using update strategy?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
How to use pmcmd utility command?
can we use mapplet as starting n ending object in mapping
how do u tune queries?
What are the diffrences between joiner transformation and source qualifier transformation?
where actually the usage of push down optimization happens...
What is difference between maplet and reusable transformation?
Teradata 
