Answer Posted / praveen kumar

step-01------>source to staging
step-02------>staging to dimension
step-03------>dimension to fact

This is the general procedure.........

How is union transformation utilized?

558

---

How to Create a folder using pmrep command?

608

---

Which development components of informatica have the highest usage?

582

---

Explain informatica architecture - version 8 / 9

655

---

What are Dimensional table?

599

---

---

What are the different types of repositories created using informatica?

646

---

how tokens will generate?

1722

---

How to load the data from a flat file into the target where the source flat file name changes daily?

568

---

where to store informatica rejected data?

667

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1748

---

What does role playing dimension mean?

613

---

Differences between version 7.x and 8.x.

1404

---

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

591

---

What differs when we choose the sorted input for aggregator transformation?

561

---

Explain lookup transformation source types in informatica

686

---