Answer Posted / vishwababu

You can use UNIQ to remove duplicates frm a file but it can
consider only same consecutive records.
Ex: if u hve records as
1 vishwa
1 Shruti
2 Ravi
3 Naveen
1 vishwa
and if u use UNIQ cmd, then you wil get vishwa, Ravi, Naveen
and vishwa.
So perform sort before using UNIQ so tat to avoid duplicates

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2240

---

Difference between sequential file and data set?

1194

---

What are the features of datastage flow designer?

1034

---

What is the difference between server job and parallel jobs?

1145

---

What are the steps needed to create a simple basic datastage job?

1227

---

How one source columns or rows to be loaded in to two different tables?

1121

---

what are the errors,warnings in datastage

2689

---

Where do the datastage jobs get stored?

1204

---

Define data aggregation?

1089

---

Why fact table is in normal form?

1238

---

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

2166

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1735

---

How many types of stage?

1172

---

What is merge stage?

1298

---

How can you write parallel routines in datastage PX?

1007

---