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
- 3069 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 |
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
tell me about your project functionality
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
Design a mapping to load a target table with the following values from the above source?
What is domain in terms of informatica?
When the informatica server marks that a batch is failed?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
what is procedure to use mapping variable in source qualifier transformation? with example
how to obtain performance data for individual transformations.
Describe expression transformation?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
What is source qualifier transformation in informatica?
Teradata 
