Answer Posted / todearhari

Just a small correction to Above Answer ,First we need to sort the Data then use the Uniq then only you will get Complete uniq records as uniq compares line by line.

Command:
Sort |Uniq

How can you write parallel routines in datastage PX?

1000

---

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

1944

---

Why we use surrogate key?

1208

---

What is active and passive stage?

1403

---

Is possible to create skid in dim,fact tables?

2624

---

Difference between in process and inter process?

1208

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2156

---

Define Merge?

1298

---

What are the repository tables in datastage?

1290

---

explain about citrix scheduling tool in datastage

2428

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2796

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3736

---

What are the types of hashed files in data stage

1098

---

What are sequencers?

1093

---

How to RD using transformer?

1407

---