Answer Posted / kumar

Hi Mr.Manthiramoorthy , thanks for valuable information. 


Could you plz tell generally how many dimensions and fact table are there in sales DWH and how frequently we load them(daily or weekly or ....).
You can also mail to 'myetlblog@gmail.com ' . Cheers...

 

Thank you.
Regards,
Kuamr.

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1794

---

How many ways are there to create ports?

1329

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8219

---

How can you define user defied event?

1029

---

Difference between Target-based loading and constraint-based loading?

998

---

What are the types of caches in lookup?

1048

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3704

---

What is aggregator transformation in informatica?

943

---

What is a filter transformation?

1043

---

Differentiate between source qualifier and filter transformation?

1578

---

Repository user profiles

1762

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2075

---

How can informatica be used for an organization?

1218

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1157

---

What are the performance considerations when working with aggregator transformation?

1152

---