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
- 7107 Views
- I also Faced
- E-Mail Answers
Answer Posted / akila
Looks like if both the flags for any ID are 'N' then all
the records of that particular ID are not sent to output.
For this, first sort the data using ID, F1, F2(all in asc
order).
Next in a transformer stage variables,
svOldID = svNewID
svNewID = ID
svCompare = If svOldID=svNewID then 'N' else 'Y'
svRejectedID= If svCompare='Y' and F1='N' and F2='N' then
ID else svRejectedID
In the output link contraint: ID<>svRejectedID
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Name the command line functions to import and export the DS jobs?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the types of hashed files in data stage
What is "fatal error/rdbms code 3996" error?
What is the purpose of interprocessor stage in server jobs?
Terminate Activity
Highlight the main features of datastage?
What are the steps needed to create a simple basic datastage job?
Define meta stage?
what is the use of skid in reporting?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the difference between in process and inter process?
How to RD using transformer?
what is the use of materialized view?
What is the difference between datastage and datastage tx?
