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
- 12709 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 to RD using transformer?
How do you reject records in a transformer?
Differentiate between odbc and drs stage?
What are the job parameters?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Which commands are used to import and export the datastage jobs?
why do u need the IOS upgradation in a FC switch
What are routines in datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what is the use of materialized view?
How you can fix the truncated data error in datastage?
What is the purpose of pivot stage and types of containers in datastage
explain about citrix scheduling tool in datastage
What is the different type of jobs in datastage?
Differentiate between datastage and datastage tx?
