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,

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  

---

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

---

how to define satge variables in transformer stage

2 Answers  

---

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

---

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

0 Answers  

---

Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,

---

Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5

2 Answers   IBM,

---

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

---

how to capture rejected data by using join stage not for lookup stage. please let me know

3 Answers   Satyam,

---

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,

---

What are the steps required to kill the job in Datastage?

0 Answers  

---