What is the difference between procedure and stored procedur?

2 Answers   IBM,

---

What are the Advantages of de normalized data?

3 Answers  

---

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

---

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

---

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

---

What is rank transformation?

0 Answers  

---

performance wise which one is better in joiner and lookup transformation

2 Answers  

---

What is decode in informatica?

0 Answers  

---

How might you approve all mappings in the archive all the while?

0 Answers  

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---