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
- 7272 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
What are the difference types of stages?
What is difference between server jobs & parallel jobs?
What is the differentiate between data file and descriptor file?
What is the use of hoursfromtime() function in transformer stage in datastage?
How many Key we can define in remove duplicate stage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
In Datastage, how you can fix the truncated data error?
What are the types of containers and how to create them?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the different options associated with dsjob command?
What is merge stage?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is difference between symmetric multiprocessing and massive parallel processing?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
