Answer / prabhu rathnam

1. remove duplicate stage
2. sort stage
3. copy stage

Answer / rohit babar

There are 3 ways by which we can remove the duplicate records
1. By using remove duplicate stage. We have control here on which record we want to remove it's first or last. There is option record to retain in remove duplicate stage where we select first or last option.

2. By using sort stage. there is option allow duplicate in sort stage. We set this option true when we want duplicate records & If we want unique records we set it to the false

3. By in-line sorting. In Partition tab of any stage when we select key base partition tech. then perform sort option will enable if we check this option next 2 option will enable which is stable & unique if we select stable that means we allow duplicate records & if we select unique that means we remove duplicate records and getting unique records

Answer / soumya

1. Sort the Data using a key column then Use 3 transformer stage Variable
SV1 = Col1
SV2 = If SV1 = SV3 then 'DUP' else 'UNQ'
SV3 (Initial value = 0)
In the constraint SV2 = 'DUP' or SV2 = 'UNQ'

2. Aggregater stage group by key col (col1) count the column
then a filter stage use count col > 1.  

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,

---

How can we achive parallelism

1 Answers   CTS,

---

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers   TCS,

---

how to delete one row in target dataset

0 Answers   Satyam,

---

what is materialized view used datastage?

1 Answers   HSBC,

---

how many types of sorting the data in data stage?

1 Answers   BoA, IBM,

---

1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?

1 Answers  

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  

---

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

---

Name the different types of Lookups in Datastage?

0 Answers  

---

How to convert RGB Value to Hexadecimal values in datastage?

0 Answers  

---