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

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

What are the different threads in DTM process?

2 Answers  

---

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

---

How to elaborate powercenter integration service?

0 Answers  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

What is the session task and command task?

0 Answers  

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

---

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---