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
- 12683 Views
- I also Faced
- E-Mail Answers
Answer Posted / koti
seq---tx----target1
|
|
target2
In Transformer use below constraint for target1.txt
UpCase(DSLink3.Field001) [1,1]= "A" Or UpCase(DSLink3.Field001) [1,1] = "B"
In Transformer use below constraint for target2.txt
tick on otherwise/log
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is difference between symmetric multiprocessing and massive parallel processing?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is a folder? Difference types of stages?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the difference types of stages?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the functionalities of link collector?
What are the functionalities of link partitioner and link collector?
What are stage variables and constants?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is size of a transaction and an array means in a datastage?
How and where you used hash file?
If you want to use the same piece of code in different jobs, how will you achieve it?
options available in sequence job to run,validate?
What all the types of jobs you developed?
