Hi Eswar, It works nicely.try once again

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

Question Posted / vijaya

9 Answers
16249 Views
Patni, I also Faced
E-Mail Answers

Answer Posted / vijaya

Hi Eswar,

It works nicely.try once again

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 purpose of interprocessor stage in server jobs?

2233

What are some prerequisites for datastage?

1098

Where the datastage stored his repository?

1089

What is the use of hoursfromtime() function in transformer stage in datastage?

1069

what is 'reconsideration error' and how can i respond to this error and how to debug this

2633

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

What are sequencers?

1115

What are the enhancements made in datastage 7.5 compare with 7.0?

1148

What is the purpose of pivot stage?

1168

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2294

Triggers,VIEW,Procedures

1220

How to Remove Duplicate using SQL?

1370

Differentiate between data file and descriptor file?

1059

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1873

what is ds administrator used for?

1171