Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7229 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
CHANGE CAPTURE
Explain entity, attribute and relationship in datastage?
How do you remove duplicate values in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Can you explain tagbatch restructure operator?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the stages in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
whom do you report?
What is the precedence of stage variables,derivations, and constraints?
Name the different sorting methods in datastage.
What is a merge?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How can we improve performance of data stage jobs?
