Answer Posted / reddymkl.dwh

Job Design:

Agg--->Filter1---------->|
| | Unique
file-->cp-------------------->Join---->Filter2---->target1
|
|-->Duplicate
Target2

Agg: use aggregator and select Agg_type=count rows and then give the Count O/P column=Cnt (User defined).

Filter1: give the condition Where=Cnt=1

U will get unique values like 200,400,500,600

Use Join (Or) Lookup stage: select left outer join

Filter2:

Where=Column_name='' (Duplicate values like 100,100,300,300,300)
Where=Column_name<>'' (Unique Values like 200,400,500,600)


u will get the right output....what ever the duplicate records.

Plz correct me if am wrong.....

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2428

---

How to clean the datastage repository?

1106

---

What is the process of killing a job in datastage?

995

---

What is ds designer?

1078

---

How can we improve performance of data stage jobs?

997

---

Is the value of staging variable stored temporarily or permanently?

979

---

What is the difference between the local container and shared container?

1080

---

What is the differentiate between data file and descriptor file?

1338

---

How do you remove duplicate values in datastage?

1134

---

What are the partitioning techniques available in link partitioner?

2258

---

What is the purpose of pivot stage and types of containers in datastage

1024

---

What is the difference between in process and inter process?

1125

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2598

---

To see hidden files in LINIX?

1506

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1392

---