Interested to Buy Any Domain ? << Click Here >> for more details...
col1
123
abc
234
def
jkl
768
opq
567
789
but i want two targetss target1 contains only numeric values
and target2 contains only alphabet values like
trg1
123
234
768
567
789
trg2
abc
def
jkl
opq
- 9 Answers
- 16245 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / srinu
at first generate row number column column 'number' then in transformer stage
create one column in constrains [ mod(number,2)=0] for this logic we get all even records mean all strings to one target
and for the second target kept a reject link all the numeric get a side
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
client know skid info?
What are the functionalities of link collector?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is ibm datastage?
Define Job control?
What are the differences between datastage and informatica?
What is usage analysis in datastage?
What is quality stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Describe the main features of datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
what are the errors,warnings in datastage
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the enhancements made in datastage 7.5 compare with 7.0?
Where the datastage stored his repository?
