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

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

---

What is resilience time?

0 Answers  

---

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

explain different types of modeling.

2 Answers  

---

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

---

Explain the shared cache and re-cache?

0 Answers  

---

What are different types of transformations available in informatica?

0 Answers  

---

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,

---

How do you change parameter when you move it from development to production.

1 Answers  

---

Separate from an archive server and a powerhouse?

0 Answers  

---

what is lookup chache?

1 Answers   Patni,

---