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 friend..
question may not clear..
my question is..
in what based on I_D s 100,103,105 don't want to send to
target?
Out of my knowledge
1.change the Field names as new field names by using modify stage as follows
Give at specification as
'ID = I_D; flag1=F1; flag2;'
2.Give the field delimiter=tab
and final delimiter=end
then u get
clear my question?
thank you..
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to implement complex jobs in data stage?
What are the areas of application?
What are stage variables, derivations and constants?
How you Implemented SCD Type 1 & Type 2 in your project?
root tree will find which is server job and which is parallel job?
How many areas for files does datastage have?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Can you define merge?
Terminate Activity
What is usage analysis in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the difference between validated and compiled in the datastage?
What is the importance of the exception activity in datastage?
What is the difference between Datastage 7.5 and 7.0?
How to clean the datastage repository?