Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

DML for excel csv source

This is a discussion on DML for excel csv source within the Data Warehousing forums, part of the Databases category; I am a newbie to Abinitio Technology and i want to know how an excel/csv (source file) can be chose as input/source file for the input file component. ...

Geeks Talk > Databases > Data Warehousing DML for excel csv source

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   10-19-2007

anil.kv Junior Member   Join Date: Sep 2007 Location: Bangalore Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

DML for excel csv source I am a newbie to Abinitio Technology and i want to know how an excel/csv (source file) can be chose as input/source file for the input file component. How can we write a DML for the same if the source file column has variable length. Thanks and appreciate help and guidelines from you all for my learnings.

Sponsored Links

#2 (permalink)   06-24-2008

lakshmipavani.g Junior Member   Join Date: Jun 2008 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts

Re: DML for excel csv source Hi For ur query, we can use delimeter example, record decimal(',') custid; string('\r\n') custname; end

Geeks Talk > Databases > Data Warehousing

« Migrate reports from 6.5 to XIR2 | What if max core set to 0 bytes »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
In my source table I have two columns	Geek_Guest	Data Warehousing	3	03-26-2008 03:20 AM
A Great Source of information	raghav83	Get Together	1	08-06-2007 02:00 AM
Mapping without using a source qualifier	Geek_Guest	Data Warehousing	5	05-17-2007 05:22 AM
source qualifier transformation	JobHelper	Data Warehousing	0	03-09-2007 07:47 AM
Source of Job	christia	Interviews	2	08-09-2006 06:57 AM

All times are GMT -4. The time now is 05:53 AM.