can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

---

why we use materialized view over view?

1 Answers   Zensar,

---

Can you access a repository created in previous version of Informatica?

1 Answers  

---

Briefly describe lookup transformation?

0 Answers  

---

What is a passive transformation?

0 Answers   Informatica,

---

Two different admin users created for repository are ______ and_______

1 Answers  

---

what are surrogate keys?

5 Answers  

---

what is the gap analysis?

1 Answers  

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

What are mapping parametres and variables in informatica?

6 Answers   TCS,

---