State the differences between sql override and lookup override?

0 Answers  

---

what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,

---

what is diff between grep and find

3 Answers   IBM, iFlex,

---

How to do the error handling of if ur source is flatfiles?

0 Answers  

---

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

In which scenario did you used pushdown optimization?

1 Answers  

---

What are reusable transformations in how many ways we can create them?

2 Answers  

---

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

---

What is difference between stored procedure transformation and external procedure transformation?

2 Answers  

---

what we require for D.modelling?

1 Answers  

---