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
- 12486 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 implement scd2 in datastage 7.5 with lookup stage
What are the repository tables in datastage?
what is use of SDR function?
Explain the situation where you have applied SCD in your project?
What are the steps needed to create a simple basic datastage job?
Lookup constraints
How do you generate sequence number in datastage?
What is the precedence of stage variables,derivations, and constraints?
What could be a data source system?
What is datastage?
Differentiate between datastage and datastage tx?
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 a datastage macro?
What are the important features of datastage?
what is ds administrator used for?
