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
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 |
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
Distinguish between informatica & datastage. Which one would you choose and why?
count number of deptno in a emp table?
How did you reconcile source with target?
plz tell me some dimentional and fact table names in banking project?
what is sparse lookup?
where the log files or tables can store in DS?
when we have to go for a sequential file stage & for a dataset in datastage?
Name the different sorting methods in datastage.
How to display all the duplicate records from the oracle Table?
What steps should be taken to improve Datastage jobs?