can you use flat file for lookup table?why?

2 Answers   HCL,

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

---

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  

---

How big was your fact table

0 Answers  

---

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

---

What is an aggregator transformation?

0 Answers  

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

---

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

---

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

9 Answers   Accenture,

---

Explain about HLD and LLD ?

16 Answers   Accenture,

---