Answer Posted / anjali

Please send me the dumps my email id is anjali21sngh@gmail.com.

Thanks.

Define enterprise data warehousing?

648

---

What are the reusable transformations?

708

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

619

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1770

---

What is the format of informatica objects in a repository?

616

---

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1750

---

What is Cognos script editor?

3805

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

750

---

Explain the etl program with few examples.

562

---

What are the issues you have faced in your project? How did you overcome those issues?

1931

---

How can we remove the duplicates from flat file source?

593

---

What happens when a session fails and you click on recover?

673

---

Explain pushdown optimization $pushdownconfig parameter - informatica

718

---

Can you generate sequence numbers without using the sequence generator transformation?

611

---

According to his methodology what all you need before you build a datawarehouse

1205

---