DSXchange

All

I have flatfile, in the flat file columns comine like this.

1~emp|2~ename|3~sal|
100|sam|1000
101|raj|2000
103|steve|3000


How to read and write this file into oracle table.

Please provide the solution.

Thanks
Raji

Hi, My source and target are Oracle stages. I am getting data into source column timestamp with milli seconds. Eg:- 01/12/2012 12:10:06.969696 AM When i am reading this from the oracle stage i am getting error in oracle stage as > Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' a...

Hi All


In the oracel stage is there any maximum limit , because i prepared one SQL that is having more then 1000 lines, i am unable to paste the complete SQL in the DATASTAGE oracle stage, there is any limit?
Please suggest me any other alternative way?



Thanks
RAJ

Hi, I am getting SRCFile as 7 rows with child records and like this r1 4 columns, 01,xxx,yyy,1 r2 6 columns, 02,aaa,bbb,ccc,ddd,2(count for child) r3 5 columns, 03,nnn,mmm,ooo,1 r3 child 5 cols 03,nnn,mmm,xyz,1 r4 have 4 cols 04, , , ,2(count) r5 have 3 cols 05, ,0 r5 child 05, ,0 Here child records...