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

Answer Posted / eswar

this is not working plz explain clearly

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the precedence of stage variables,derivations, and constraints?

604


What is the sortmerge collector?

672


What are the features of datastage flow designer?

646


How complex jobs are implemented in datstage to improve performance?

608


Can you define merge?

674






what are the errors,warnings in datastage

2173


Define orabulk and bcp stages?

700


what is flow of project?

1567


How we can covert server job to a parallel job?

605


Define Data Stage?

657


What is orabulk stage?

650


Define Merge?

889


What is a datastage job?

632


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1798


What are the components of datastage?

664