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
- 2929 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 |
How Union Transformation is an Active Trans?
What is a test load?
expain about the tune parameters?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
plz plz plz send client names and project names in informatica?
What are mapplets?
How do we call shell scripts from informatica?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
which one is better either active or passive transformation in informatica
Router T/R is active but some people are saying it is also passive which is exactly right?
How can repository reports be accessed without sql or other transformations?
What is a filter transformation and why it is an active one?
Teradata 
