Need help in reading source file and loading data into DB

user_2883 · Post by **user_2883** » Thu Jun 30, 2011 9:04 am

Hi,

I have a requirement as below:

My source file is an excel sheet having data in below format:

1
Age: 27 Sex: Male
NVR0035733
Elector's Name:
Father's Name:
House No:
K SATYA NARAYANA
SURYA NARAYANA
01/01/2027
2
Age: 38 Sex: Male
NVR0035634
Elector's Name:
Father's Name:
House No:
SAYED HABIBOOR
SAYED JANULADEDDIN
01/01/1939
3
Age: 37 Sex: Male
NVR0035675
Elector's Name:
Father's Name:
House No:
AKHILESH SINGH
SRIKRISHNA SINGH
01/01/1939

I need output as below:
SNO Age Sex ID Elector's Name Father's Name House No:
1 27 Male NVR0035733 K SATYA NARAYANA SURYA NARAYANA 01/01/2027
2 38 Male NVR0035634 SAYED HABIBOOR SAYED JANULADEDDIN 01/01/1939
3 38 Male NVR0035675 AKHILESH SINGH SRIKRISHNA SINGH 01/01/1939

chulett · Post by **chulett** » Thu Jun 30, 2011 9:19 am

What have you tried? Do you have the spreadsheet on the DataStage server in a delimited format like csv or is it still an xls file?

user_2883 · Post by **user_2883** » Thu Jun 30, 2011 9:30 am

I will be getting excel through mail and I convert it to csv and put it in datastage server. So I can say that CSV file will be available in Datastage server as source.

Regards
Lakshmi

ray.wurlod · Post by **ray.wurlod** » Thu Jun 30, 2011 4:38 pm

Once you know the format of the CSV create a source-to-target mapping specification and base your DataStage design upon that.