What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

0 Answers   Wipro,

---

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  

---

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

---

How can we improve the performance in datastage?

0 Answers  

---

---

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

how to call sequential generator in datastage?

1 Answers   IBM,

---

plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,

---

How do you find the number of rows in a sequential file?

1 Answers  

---

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,

---