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

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

how many data models u have done in informatica project?

2 Answers   TCS,

---

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

---

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

---

What is predefined event?

1 Answers  

---

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

---

Why sorter is an active transformation?

0 Answers   Informatica,

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

What is the status code?

1 Answers  

---