1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

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

Define project in datastage?

680

Difference between data warehousing and olap?

661

what is the difference between == and eq in UNIX shell scripting?

985

What is the difference between an operational datastage and a data warehouse?

647

What is active and passive stage?

897




Describe link sort?

663

How to convert RGB Value to Hexadecimal values in datastage?

3468

What is difference between join, merge and lookup stage?

648

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3772

What are the stages in datastage?

645

What are constraints and derivations?

662

Where do you see different stages in the designer?

648

AGGREGATOR default datatype

951

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1757

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3393