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
How many types of sorting methods are available in datastage?
How do you start developing a datastage project?
whom do you report?
Which algorithm you used for your hashfile?
State the difference between an operational datastage and a data warehouse?
What is a ds designer?
What is the difference between passive stage and active stage?
how to write server Routine coding?
What could be a data source system?
How to read multiple files using a single datastage job if files have the same metadata?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Define APT_CONFIG in Datastage?
How many types of views are there in a datastage director?
Lookup constraints