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
- 7230 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
how can we create rank using datastage?what is the meaning of rank?
What are the functionalities of link partitioner and link collector?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
I have a few records just I want to store data in to targets cycling way how?
how many rows sorted in sort stage by default in server jobs
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
what is the use of surogate key in datastage
What is a ds designer?
What is ds designer?
What is the flow of loading data into fact & dimensional tables?
how to sort two columns in single job in datastage.
What are the enhancements made in datastage 7.5 compare with 7.0?
How do you register plug-ins?
What is the difference between Datastage 7.5 and 7.0?
what is the difference between == and eq in UNIX shell scripting?
