Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 7231 Views
- I also Faced
- E-Mail Answers
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
Which warehouse using in your datawarehouse
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Define oconv () and iconv () functions in datastage?
What are the job parameters?
What are the steps required to kill the job in Datastage?
What is the difference between passive stage and active stage?
What are the stages in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
how can we create rank using datastage?what is the meaning of rank?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Can you explain engine tier in information server?
What is difference between server jobs & parallel jobs?
What are the enhancements made in datastage 7.5 compare with 7.0?
AGGREGATOR default datatype
