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
- 7267 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
Why fact table is in normal form?
what is the use of materialized view?
What are the functionalities of link partitioner and link collector?
How a server job can be converted to a parallel job?
How to convert RGB Value to Hexadecimal values in datastage?
What is the difference between account and directory options ?
What are the different types of lookups in datastage?
How a routine is called in datastage job?
Describe stream connector?
Highlight the main features of datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the some differences between 7.x and 8.x version of datastage?
What is staging variable?
Differentiate between operational datastage (ods) and data warehouse?
What are the different plug-ins stages used in your projects?
