Answer / rao

Firstly we have to load the dimension tables.from dimension
tables take the primary key reference and load the Fact table.
That mean if you have dimensions like product,branch,customer,
we load product id,branch id,customer id(only surrogate keys)
to fact table .later measure will be loaded.

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

---

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,

---

What is the functionality of update strategy?

2 Answers  

---

what is DSS?

3 Answers  

---

How do you load alternate records into different tables through mapping flow?

0 Answers  

---

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

---

how to use incremental load?

2 Answers   TCS,

---

How can you differentiate between powercenter and power map?

0 Answers  

---

What is an expression transformation?

0 Answers  

---