How do you remove duplicate values in datastage?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

Whats difference betweeen operational data stage (ods) and data warehouse?

0 Answers  


what is combinability and non combinability?

2 Answers  


Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  


create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,


how to handle null values using transformer stage?

1 Answers  






Define repository tables in datastage?

0 Answers  


can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,


How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  


How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,


What are the types of hashed files in data stage

0 Answers  


what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,


what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,


Categories