SOURCE LIKE
I_D,F1,F2
---------
100,N,Y
100,N,N
100,Y,N
101,Y,Y
101,N,Y
102,Y,N
103,N,N
104,Y,Y
105,N,N
106,N,Y
102,N,Y
105,Y,Y
O/P LIKE
ID flag1 flag2
101 Y Y
101 N Y
102 Y N
102 N Y
104 Y Y
106 N Y
Answer Posted / vaibhav
I think, here the question is... if F1 & F2 both are 'N' then the records with same I_D should be dropped.. correct Prasad?
if this is the case we need to find ans for this scenario..
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
whom do you report?
How many Key we can define in remove duplicate stage?
Explain Quality stage?
how to implement scd2 in datastage 7.5 with lookup stage
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is a ds designer?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How do u convert the columns to rows in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the stages in datastage?
Is it possible to query a hash file?
what is the use of skid in reporting?
Define Job control?
How can you write parallel routines in datastage PX?
root tree will find which is server job and which is parallel job?