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 datastage sequences?
Can you explain tagbatch restructure operator?
What are the stages in datastage?
How can we improve the performance in datastage?
which r the connectors used in san?
How many types of sorting methods are available in datastage?
What is a ds designer?
Why we use surrogate key?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is meta stage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is orabulk stage?
how to implement scd2 in datastage 7.5 with lookup stage
Distinguish between informatica & datastage. Which one would you choose and why?
What can we do with datastage director?