topic Re: Want to load data from oracle to .CS V file with retaining data type. in Talend Studio

Want to load data from oracle to .CS V file with retaining data type.

Anonymous — Sat, 16 Nov 2024 10:01:59 GMT

Hi,
I have and requirement to load data from source data i.e Oracle to a .csv file and the DATA Type of the Oracle DB should be retained as i have an Date time field Datatype in Oracle , which should match as Date time column in .csv file. i mean to say the format in the .csv file should match with source for my case in csv file it should have data format column in csv file.
Any leads and help will be much appreciated.
Thanks,
Neeraj

Re: Want to load data from oracle to .CS V file with retaining data type.

vapukov — Thu, 02 Mar 2017 11:42:46 GMT

what the problem?

Re: Want to load data from oracle to .CS V file with retaining data type.

Anonymous — Thu, 02 Mar 2017 11:57:08 GMT

Dates are stored as numbers in Oracle. The way you see them in your query analyser is just formatting. ALL data in a CSV is in a String format, but can be represented in any way you wish.

Re: Want to load data from oracle to .CS V file with retaining data type.

Anonymous — Thu, 02 Mar 2017 12:48:08 GMT

Problem is the date field in oracle when moved to a CSV file the date column is in string format or text format... i want to use pivot from other tabs to populate a report so, if it is string or text i have to do manually which kills time and want to avoid this manual work.
please suggest how this could be fixed to get the date format in the csv file rather than string or text. i am using talend routine to load data from Oracle to CSV file.

Re: Want to load data from oracle to .CS V file with retaining data type.

Anonymous — Thu, 02 Mar 2017 12:52:47 GMT

i want it as a Date column in csv

Re: Want to load data from oracle to .CS V file with retaining data type.

TRF — Thu, 02 Mar 2017 13:23:02 GMT

Hi,
As said by @rhall_2.0 all data in a csv file are represented as string.
It's your responsability to format these data according to what you expect.
For example, exponential representation for numbers, and so on.
How do expect the date format?
Regards,
TRF

Re: Want to load data from oracle to .CS V file with retaining data type.

Anonymous — Thu, 02 Mar 2017 13:38:46 GMT

Is there no way to send as Date format in csv or excel through Talend.

Re: Want to load data from oracle to .CS V file with retaining data type.

TRF — Thu, 02 Mar 2017 14:07:28 GMT

Into Excel you can define a column as date datatype.
Into CSV, data are stored as strings - however, tell us the representation you expect in this case.
Of course you can convert a date to its string representation and decide the format.

Re: Want to load data from oracle to .CS V file with retaining data type.

_AnonymousUser — Fri, 03 Mar 2017 08:03:51 GMT

Hi Neeraj,
CSV files are not capable of having datatype defined. I guess you want it to be like how it is in database or excel. But defining datatype in CSV is just not possible. For example when you open a csv in notepad you will not see anything like datatype as you see in database. However all the tool which provide import csv has option for user to define datatype for each column. Like if you import csv into excel, excel will ask you in wizard to define datatype of each column.
Hope this help.
Thanks,
Anupam

Re: Want to load data from oracle to .CS V file with retaining data type.

Anonymous — Fri, 03 Mar 2017 09:20:28 GMT

Thanks Anupam for clarification, Can you please help me getting the column in date format in excel while loading data from Oracle... please help with some screen shots as when i try doing it it just gives absurd character