Yes i have tried that...it doesnt reverse engineer the data store...instead it shows an error saying "SnpModel" does not exist...i have even commented on that post so that the OP can share the complete code
Have you tried reverse engg a data store (and not model) using ODI SDK
as you mention in thread The specified item was not found.
you want reverse engineer data store for file technology and format is FIXED
What reverse engineer do... it automatically creates column with data Type and length for u; same u can do by creating columns thru code;
I did same, as I don't found API for reverse engg data store when file format is fixed
my code snippet is
OdiColumn odiColumn = new OdiColumn(DataStore, colName);
This code is working for me
@Deepali : when u reverse engg ur delimited file, were you able to see the data ..for eg when u create interface or something.....setting all the parameters for reverse engg including column name, format etc is ok but you should mainly see the data when u use the datastore in an interface...
so did u try that? did u use the data store in the interface using studio?
Thanks for your quick reply
Also can u specify what does your filedescriptor contain?
My text file is like this
but on reverse engg i cant see any data in the data store
Also, how to specify physical length and not logical length while reverse engg?
When I reverse engg my delimited or fixed file, I am able to see the data of datastore; I used same datastore in interface
Yes , I used the data store in interface using code(sdk)
I am not doing anything manually in studio; everything is done through java code (using sdk)...but I have checked data of datastore by right clicking on it, its giving proper data
filedescriptor contains start position and num of bytes
your text file is looks like FIXED format,
my Delimited format text file:
and FIXED format text file:
if file format is Delimited we need not to worry about physical length or logical length, bcoz we are able to do reverse engg for that; which automatically set all fields
odiColumn.setLength(length); method sets both physical and logical length