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
- 12894 Views
- I also Faced
- E-Mail Answers
Answer Posted / bg
Job design will be:
seq --- Tx ---- target.txt
|_____ reject.txt
IN transformer use below constraint for target.txt
Left(city,1)='A' or Left(city,1)='B'
Check the otherwise and send it to reject file.
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
In Datastage, how you can fix the truncated data error?
What are orabulk and bcp stages?
Differentiate between operational datastage (ods) and data warehouse?
How do y read Sequential file from job control?
Notification Activity
Define APT_CONFIG in Datastage?
how to sort two columns in single job in datastage.
Describe the architecture of datastage?
What is the project in datastage?
How can one find bugs in job sequence?
What is the difference between account and directory options ?
What are the different layers in the information server architecture?
What is a datastage job?
Why we use surrogate key?
How a routine is called in datastage job?
