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
- 2891 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 you know about transaction control transformation?
Write the prerequisite tasks to achieve the session partition?
What are the types of caches in lookup? Explain them.
What is an aggregator transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Define Pmrep command?
What is meant by lookup transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What are the different ways to implement parallel processing in informatica?
How many transformations can be used in mapplets.
What is different between the data warehouse and data mart?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are mapplets? How is it different from a Reusable Transformation?
What is a connected transformation?
Briefly define reusable transformation?
