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
- 7104 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
On which interface you will be working as a developer?
What is the difference between operational data stage (ods) and data warehouse?
Define APT_CONFIG in Datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Can you explain how could anyone drop the index before loading the data in target in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Define Job control?
What is a quality stage in datastage tool?
What are sequencers?
What are some different alternative commands associated with "dsjob"?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
what are the errors,warnings in datastage
What is the purpose of pivot stage and types of containers in datastage
What are the main features of datastage?
