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
- 12707 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
Can you explain tagbatch restructure operator?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
what is 'reconsideration error' and how can i respond to this error and how to debug this
how many rows sorted in sort stage by default in server jobs
What is the difference between passive stage and active stage?
What is the difference between an operational datastage and a data warehouse?
AGGREGATOR default datatype
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How a routine is called in datastage job?
whom do you report?
What are stage variables and constants?
Explain the importance of surrogate key in data warehousing?
What is difference between join, merge and lookup stage?
What steps should be taken to improve Datastage jobs?
What are the difference types of stages?
