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 / 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?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the difference between passive stage and active stage?
Which warehouse using in your datawarehouse
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How a server job can be converted to a parallel job?
how can we create rank using datastage?what is the meaning of rank?
how to implement scd2 in datastage 7.5 with lookup stage
What are the different plug-ins stages used in your projects?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the differences between datastage and informatica?
what are the errors,warnings in datastage
What are the types of jobs we have in datastage?
What is the purpose of pivot stage and types of containers in datastage
what is the use of skid in reporting?