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
- 4 Answers
- 6075 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vaibhav
I think, here the question is... if F1 & F2 both are 'N' then the records with same I_D should be dropped.. correct Prasad?
if this is the case we need to find ans for this scenario..
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / akila
Looks like if both the flags for any ID are 'N' then all
the records of that particular ID are not sent to output.
For this, first sort the data using ID, F1, F2(all in asc
order).
Next in a transformer stage variables,
svOldID = svNewID
svNewID = ID
svCompare = If svOldID=svNewID then 'N' else 'Y'
svRejectedID= If svCompare='Y' and F1='N' and F2='N' then
ID else svRejectedID
In the output link contraint: ID<>svRejectedID
| Is This Answer Correct ? | 0 Yes | 1 No |
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
What are the repository tables in datastage?
Which algorithm you used for your hashfile?
What is the use of hoursfromtime() function in transformer stage in datastage?
what is the main differences between Lookup, Join and Merge stages?
what are the devoleper roles in real time? plz tell i am new to datastage....
what is a message handler
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
How to generate surrogate key without using surrogate key stage?
What can we do with datastage director?
Teradata 
