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
Explain Quality stage?
how many rows sorted in sort stage by default in server jobs
What is a datastage job?
What is difference between server jobs & parallel jobs?
What is the difference between an operational datastage and a data warehouse?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Differentiate between validated and Compiled in the Datastage?
How do you register plug-ins?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are orabulk and bcp stages?
What are the difference types of stages?
How many types of stage?
What is the differentiate between data file and descriptor file?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are the partitioning techniques available in link partitioner?