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
How can we improve performance of data stage jobs?
What is the purpose of pivot stage?
How do you generate sequence number in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Can you explain players in datastage?
What can we do with datastage director?
what is use of SDR function?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the difference between in process and inter process?
What are the different common services in datastage?
What is the difference between validated and compiled in the datastage?
Name the third party tools that can be used in datastage?
What are the different types of lookups in datastage?
How rejected rows are managed in datastage?
What is ds designer?