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
Answer Posted / bharath
Hi,
please find the below answer.
|------seq1
src---->trans-----
|------seq2
in transformer stage give constraint as follows
src.f1="N" And src.f2="N"
check other wise link on seq2link.
then you get..
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the steps needed to create a simple basic datastage job?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
how to export or import the jobs in .ISX file
How can you write parallel routines in datastage PX?
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 ?
I have a few records just I want to store data in to targets cycling way how?
Could anyone give brief explanation bout datastage admin
Where do you see different stages in the designer?
What is ibm datastage?
Differentiate between validated and Compiled in the Datastage?
How many types of hash files are there?
What is the precedence of stage variables,derivations, and constraints?
What is a quality stage in datastage tool?
what is the use of surogate key in datastage
What is the difference between odbc and drs stage?