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 / 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
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How do you import and export data into datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Difference between data warehousing and olap?
Describe the architecture of datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
Describe link sort?
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.
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How do you register plug-ins?
What is the command line function to import and export the ds jobs?
What is use Array size in datastage
CHANGE CAPTURE
What are the various kinds of the hash file?
Why we use surrogate key?