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 some different alternative commands associated with "dsjob"?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are routines in datastage? Enlist various types of routines.
What are routines in datastage?
What are the steps needed to create a simple basic datastage job?
Which algorithm you used for your hashfile?
Can you explain link buffering?
What are the different types of lookups in datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
AGGREGATOR default datatype
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How many types of views are there in a datastage director?
What are the various kinds of the hash file?
Define Data Stage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?