Answer Posted / pvn

no of nodes

What are the various kinds of the hash file?

1118

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

978

---

Have you have ever worked in unix environment and why it is useful in datastage?

1101

---

How can you write parallel routines in datastage PX?

991

---

What is "fatal error/rdbms code 3996" error?

1221

---

whom do you report?

1897

---

How to read multiple files using a single datastage job if files have the same metadata?

1202

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1086

---

Give an idea of system variables.

983

---

Which commands are used to import and export the datastage jobs?

1384

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2188

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

890

---

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.

3994

---

What all the types of jobs you developed?

1139

---

which r the connectors used in san?

2158

---