Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is 
Empno
1                               
2
3
4
5
6
7
8
9
10                             

                               
                               

Answer Posted / xyz

use remove duplicate stage with first as the option for duplicate to return

Is This Answer Correct ?    0 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we improve performance of data stage jobs?

612


What is the purpose of pivot stage?

600


How do you generate sequence number in datastage?

620


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1622


Can you explain players in datastage?

701






What can we do with datastage director?

666


what is use of SDR function?

4706


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

1693


What is the difference between in process and inter process?

662


What are the different common services in datastage?

698


What is the difference between validated and compiled in the datastage?

697


Name the third party tools that can be used in datastage?

610


What are the different types of lookups in datastage?

622


How rejected rows are managed in datastage?

913


What is ds designer?

649