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
- 12632 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh reganti
Job design will be:
seq --- Tx ---- target.txt
------rejct.txt
IN transformer use below constraint for target.txt
City[1,1] = 'A' or City[1,1] = 'B'
IN transformer use below constraint for reject.txt
otherwise
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How we can covert server job to a parallel job?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the types of containers in datastage?
What are routines in datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the different types of lookups in datastage?
On which Dimension Table you implemented SCD Type in your Project
Can you highlight the main features of ibm infosphere information server?
What are 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.
Explain ibm infosphere information server and highlight its main features?
Can you filter data in hashed file?
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 differences between datastage and informatica?
How to read multiple files using a single datastage job if files have the same metadata?
