Answer Posted / hk

let make it more simpler use NullToValue() or NullToempty()
function ,

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)

866

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2097

---

Differentiate between validated and Compiled in the Datastage?

1193

---

What are some different alternative commands associated with "dsjob"?

1079

---

What all the types of jobs you developed?

1115

---

project Steps,hits, Project level HArd things,Solved methods?

2063

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2554

---

root tree will find which is server job and which is parallel job?

1882

---

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.

3968

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3263

---

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

952

---

Define APT_CONFIG in Datastage?

1019

---

What is the precedence of stage variables,derivations, and constraints?

1027

---

On which Dimension Table you implemented SCD Type in your Project

1969

---

How do you import and export data into datastage?

1165

---