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?????
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
What is the different type of jobs in datastage?
EXPLAIN SCD
How will you move hashed file from one location to another location?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Explain ibm infosphere information server and highlight its main features?
Define ds designer?
Difference between server jobs & parallel jobs?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the features of datastage flow designer?
what is flow of project?
What is datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are the some differences between 7.x and 8.x version 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 repository tables in datastage?