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
- 16270 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
How do you import and export data into datastage?
How to manage date conversion in Datastage?
Difference between data warehousing and olap?
What is the project in datastage?
How do you schedule or monitoring the job?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
CHANGE CAPTURE
What is the difference between the local container and shared container?
What is active and passive stage?
What are the steps required to kill the job in Datastage?
State the difference between an operational datastage and a data warehouse?
What is oci?
How to Remove Duplicate using SQL?
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 main differences you have observed between 7.x and 8.x version of datastage?
