Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

---

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

---

Can we get 1st record through Informatica(without sequence number).

0 Answers  

---

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

---

Global and Local shortcuts. Advantages.

0 Answers  

---

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

0 Answers   Informatica,

---

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

---

How to load last n records of file into target table - informatica

0 Answers   Informatica,

---

what is the difference between stop and abort

2 Answers  

---

How do you take back up of repository?

0 Answers  

---

Why do we use DSS database for OLAP tools?

2 Answers  

---