Answer Posted / ankit gosain

Hi,

The solution to the problem can be achieved by the below
job structure & settings:

Source---->SortStage---->Transformer---->Tgt1,Tgt2,Tgt3

1. In Sort Stage, sort in assending mode w.r.t. source
column (say col1) & Create a change key column (say
ChangeKey).
2. In Transformer stage, create a stage variable (say
count) & it's derivation would be:
if ChangeKey=1 then 1 else count+1
3. Constraint for Tgt1 => col1=d1
Constraint for Tgt2 => col1=d2
select otherwise constraint for Tgt3.

Cheers,
Ankit :)

What all the types of jobs you developed?

665

---

Describe routines in datastage? Enlist various types of routines.

579

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

772

---

What is meta stage?

577

---

What is oci?

850

---

---

If you want to use a same piece of code in different jobs, how will you achieve this?

790

---

How to convert RGB Value to Hexadecimal values in datastage?

3456

---

What are the types of containers and how to create them?

556

---

explain about citrix scheduling tool in datastage

1808

---

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

645

---

What are the different type of jobs in datastage?

604

---

How a server job can be converted to a parallel job?

619

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1625

---

what is the use of materialized view?

958

---

How will you move hashed file from one location to another location?

1655

---