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
15929 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

how to abort the job its matain duplicates?

2536

Define oconv () and iconv () functions in datastage?

1345

What is orabulk stage?

996

Why fact table is in normal form?

1152

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

1837

How we can covert server job to a parallel job?

1064

EXPLAIN SCD

1341

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1143

Explain usage analysis in datastage?

1098

Is it possible to query a hash file?

1955

What are the components of ascential data stage?

1115

What is data partitioning?

1138

How do y read Sequential file from job control?

15810

What steps should be taken to improve Datastage jobs?

1008

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2045