by using right and left function with loop function we can achieve this one

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is
Empno
1
2
3
4
5
6
7
8
9
10

Question Posted / david

Answer Posted / david

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to read the length of word in unix?

1378

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2463

Differentiate between odbc and drs stage?

1050

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1387

why do u need the IOS upgradation in a FC switch

2281

Difference between sequential file and data set?

1197

How do u convert the columns to rows in datastage?

1194

Define Job control?

1142

in oracle target stage when we use load option and when we use upsert option?

2285

Can you filter data in hashed file?

3772

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2443

client know skid info?

2080

What is the purpose of pivot stage and types of containers in datastage

1036

Can you explain kafka connector?

1308

Define APT_CONFIG in Datastage?

1076