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

What are the enhancements made in datastage 7.5 compare with 7.0?

709


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1930


How to read multiple files using a single datastage job if files have the same metadata?

740


Define ds designer?

768


How to reverse the string using unix?

2812






What is ds designer?

657


What are the main differences you have observed between 7.x and 8.x version of datastage?

624


What is data partitioning?

745


How you Implemented SCD Type 1 & Type 2 in your project?

3699


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

703


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1762


explain about citrix scheduling tool in datastage

1812


What are the functionalities of link partitioner and link collector?

598


Define Data Stage?

644


What is the difference between operational data stage (ods) and data warehouse?

675