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
- 6316 Views
- I also Faced
- E-Mail Answers
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
What are the benefits of datastage?
How to implement complex jobs in data stage?
How do you schedule or monitoring the job?
what are the devoleper roles in real time? plz tell i am new to datastage....
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is the process of killing a job in datastage?
To see hidden files in LINIX?
Demonstrate experience in maintaining quality process standards?
What are transforms and what is the differenece between routines and transforms?
What is meta stage?
How do you start developing a datastage project?
How many types of sorting methods are available in datastage?
Difference between sequential file and data set?
How to Remove Duplicate using SQL?
What are the types of containers?
