how do u capture duplicates through sort & transformer
Answer Posted / kiran
Hai..,
In sort stage we have one property...its create key change
column.
In Transformer stage ,we have to write if then else
condition.....
Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
root tree will find which is server job and which is parallel job?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Can you explain players in datastage?
How a routine is called in datastage job?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what are the devoleper roles in real time? plz tell i am new to datastage....
What is difference between join, merge and lookup stage?
Can we use target hash file as a lookup ?
How do you register plug-ins?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are the repository tables in datastage?
What are the different type of jobs in datastage?
What are the main features of datastage?
What are the features of datastage flow designer?