Current position:  Home > Default > Column types on a flat file

Column types on a flat file

Time:November 30
Advertisement
I am using a flat file as a target and when I define column types as anything other then string I get the following error on execution
000 : null : com.sunopsis.jdbc.driver.file.a.i
com.sunopsis.jdbc.driver.file.a.i
     at com.sunopsis.jdbc.driver.file.a.d.setDate(d.java)
     at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java)
     at com.sunopsis.sql.SnpsQuery.addBatch(SnpsQuery.java)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrders(SnpSessTaskSql.java)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSqlI.treatTaskTrt(SnpSessTaskSqlI.java)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
     at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
Advertisement
hi lpantuso ,
suppose u want to transfer file data like
xxxx 1111 12-01-2005
yyyy 2222 12-03-2007
zzzz 3333 01-05-2007
to another blank file so you have do folloowing steps
craete file data server for individual data server suppose you r developing application on ur desk to so create single file dat server in topology manager with proper jdbc url and driver name as
Jdbc driver as : com.sunopsis.jdbc.driver.file.FileDriver choose from drop down menu
and add url as: jdbc:snps:dbfile
now for each different folder create physical schema with the schema and work schema name as the location of the folder .
click on context tab add the proper logical schema name
come to designer window
Create individual model for each physical schema (for each folder I can say)
Use the proper logical schema name (while you'll select technology as file all the logical schema related to the technology wil be displayed just select ur logical schema)
than create individual datastore for each file (you can create two data store at max for each file).
assuming you r using delimited file.
while reversing existing source file you will have all the columns of the file
change data type and size of the fields.
For the target File datastore file should be there wid blank structure so add column wid proper data type, for second field use numeric and for date use string as datatype .Size must be appropriate for the target file otherwise you'll have warning at designing time.
create an interface
use Global context with "Sunopsis memory engine" as staging area other than target.
then map the source and target file
at Flow tab
choose
LKM File to SQl for source area
NO LKM is there for Staging area
IKM SQL to file append for target (If these are not automatically updated)
Then try to execute,it's working
Note : If you want to transfer table data to a file then for date type data you have to check following things
1) at the time of mapping of date type from table to file interface use
to_char(<SourceTableNameAlias> . <columnName>) instead of
<SourceTableNameAlias> . <columnName>
and date type data field of the target file should be String type.............

How to split column wise into separate flat files in ssis

2015-10-11

IN SSIS... 1.---->I have a sales table country wise regions  like (india, usa, srilanka) .... india usa srilanka a b c d e f so i want output like in flat file1.txt has india               flat file2.txt has usa             flat file3.txt has srilank

Reading a semi column delimited multi line Flat file on KM repository

-0001-11-30

Hi, I have a requirement in our project to read a multi line, semi column delimited flat from kept on the Knowledge Management repository and display the contents in the Portal. I had tried couple of options and was unable to read the file. I am not

N IDOCS OF SAME TYPE TO A FLAT FILE

2015-10-11

HI EXPERTS,                   I have a scenario in which i have to receive IDOC and retrieve the value of a particular field.Giving the value in this field as input parameter to an RFC call get the number of IDOCs sent with this value(of the particul

Flat File Import, Ignore Missing Columns?

2015-10-11

The text files I'm importing always contain a fixed set of columns for example total number of full set of columns is 60, or a subset of those columns (some csv contain 40 columns, some contain 30 or 20 or any other number.) .  I would like to import

Import flat file to multiple tables based on identifier column

-0001-11-30

Hello, I am trying to setup a package that will import one pipe-delimited flat file (a utility bill) to multiple data tables based on the value of the first column.  I have been told it is similar in format to an EDI file, but there are some differen

Copying TEXT column from flat file into SQL results in empty fields....

-0001-11-30

I'm copying TEXT column from SQL to Flat file (ragged right fixed width) - DT_TEXT. It copies fine and I''ve checked the output file. Now, while trying to copy the flat file to sql server in another system. I find all the fields are empty. When I pre

Unable to upload delimited flat file (Datastore)

2015-10-11

Dear All, Drilling down the tutorial:  ODI11g: Creating an ODI Project and Interface: Exporting a Flat File to a Flat File facing quite a problem while reverse-engineering delimited flat file (Datastore ->Model). No matter which type of delimited fla

Data convertion while exporting data into flat files using export wizard in ssis

2015-10-11

Hi , while exporting data to flat file through export wizard the source table is having NVARCHAR types. could you please help me on how to do the data convertion while using the export wizard? Thanks.Hi Avs sai, By default, the columns in the destina

Error loading essbase data into flat files through DIM

-0001-11-30

Hi All, While running the session in DIM 8.1.1 which will load data from Hyperion essbase (11.1.1.3) to flat file it fails. From the log file it shows failes to load the HASReader plugins. All the environmental variables are properly set. Still I am

How to load a flat file into BW-BPS using Web Browser

2015-10-11

Hello, i have a problem with the "How to do Paper". I want to upload a Excel CSV file , but the paper only describes a txt file Uplaod. Does anybody can help me ?Thanks !You need to parse the line coming in from the flat file... You can do this

Error when exporting to flat file in ODI 11g

2015-10-11

This works ok in ODI 10g. I'm using IKM SQL to File Append on Windows Server 2008 R2 Getting the following error when exporting to a flat file in ODI 11g: ODI-40406: Bytes are too big for array I've seen a couple of threads like this on the forum, bu

Doubts in SAP(Idoc)-XI-Flat file scenario

2015-10-11

Dear All, I am sending Delivery Idoc from R/3 and I am able to view the Idoc in XI in transaction IDX5. Also i m able to see the XML structure with the data of the idoc in SXMB_MONI. Now as per my scenario I have to download this to a flat file from

Flat  File to InfoCube Load Issue

2015-10-11

Hello All,               I am newbie in the SAP BW land. Probably a simple question to BW Experts. This is crude implementation of the Fu and Fu example. Environment SAP  BW 7.0 Iam trying to load a flat file to the Info Cube. 1. I am able to success

Export SQL View to Flat File with UTF-8 Encoding

2015-10-11

I've setup a package in SSIS to export a SQL view to a flat file and it's working fine.  I now need to make that flat file UTF-8 encoded.  The package executes but still shows the files as ANSI encoded. My package consists of a Source (SQL View) -> D

Flat-File Upload - Large File Size

2015-10-11

Hello, i have to upload a very large flat-file with a size of 200 to 300 MB. The upload from the presentation server (local win xp client) fails after exceeding the time limit, because the upload performs in online-mode. I have to approaches to fix t

Number formatt for flat file

-0001-11-30

hi for 0amount field i am getting data in excel like                 -535.905.031.022.492                -111.801.379.067.257                433.124.355.469.709 -0.405316272683086 -0.378415176841429 -0.404278225058806 this allignmnet will be fine or

Convert IDOC to flat file - How to guide

-0001-11-30

Hello, I have found the how to guide for converting IDOCs to FlatFiles via ABAP Mapping. https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/46759682-0401-0010-1791-bd1972bc0b8a What is not clear to me. This sounds like I do not

Can i able to put filter for my source flat file?

-0001-11-30

Hi all, Please help me with the best practise of ODI. My source is flat file and i want to put filter. can i able to put filter for my source flat file? If yes, please help me with the best practise of applying filter. Regards SureshHi , If you are t

How to make flat file for LSMW

-0001-11-30

I would like to make flat file for LSMW,I have all the list of field details.I am going to use direct method in LSMW.can anyone explain.I have to type Tcode in flat file?pls send some sample flat files also for direct method.In the top u only need to