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
- 7444 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
Explain how a source file is populated?
What is process model?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How can we improve performance of data stage jobs?
What are the various kinds of the hash file?
What is size of a transaction and an array means in a datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are the difference types of stages?
What are some different alternative commands associated with "dsjob"?
How to clean the datastage repository?
What is a datastage job?
How many areas for files does datastage have?
What is the method of removing duplicates, without the remove duplicate stage?
How to Remove Duplicate using SQL?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
