Interested to Buy Any Domain ? << Click Here >> for more details...
I have a source table with column name CITY having 100
records,
I want target table with column name start with 'A'
and 'B',remaining columns as reject outputs.
how can achieve this by data stage?please help me?????
- 5 Answers
- 12710 Views
- I also Faced
- E-Mail Answers
Answer Posted / naresh
Hi,
sequential-----filter------ds
in filter stage
where clause= city like 'A%' OR CITY LIKE 'B%'
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Which commands are used to import and export the datastage jobs?
Which algorithm you used for your hashfile?
Can we use target hash file as a lookup ?
How many Key we can define in remove duplicate stage?
How we can covert server job to a parallel job?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is apt_config in datastage?
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.
Notification Activity
Difference between sequential file and data set?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What all are the different way to run a job?
What is process model?
What are the types of views in datastage director?
Does datastage support slowly changing dimensions ?
