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
- 7285 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
Define orabulk and bcp stages?
How to read the length of word in unix?
Why do you need stage variables?
What is the difference between account and directory options ?
What are the different common services in datastage?
What is size of a transaction and an array means in a datastage?
Why fact table is in normal form?
Which commands are used to import and export the datastage jobs?
What is the use of datastage designer?
Is it possible to query a hash file?
What are the important features of datastage?
Differentiate between Join, Merge and Lookup stage?
How to clean the datastage repository?
how do u catch bad rows from OCI stage? And what CLI stands for?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
