This content has been marked as final. Show 4 replies
is this going to be the regular pattern of the file? if so, no problem..you can define 4 columns..the first being date..and so..on..creating a source datastore and map accordingly to the target..1 person found this helpful
It is not that straight forward
i want to load the first row data which came as 20112012 in a separate column let's say insert_date
and the count of rows exclude the first row and last row i will take the count of the rows and try to insert into one table..
I assume there is only 1 "date row", and it's always the first row of the file ?1 person found this helpful
If so, you should extract this date in an ODI Variable.
Then ignore this first row in your ODI interface. But use the variable to populate your "insert_date" column.
If you can't directly read the file to extract this row, create a specific interface that will load your flat file with the filter ROWNUM=1 (filter on staging area zone). This interface will only extract the date in a temporary table. You can use the "yellow interface" for that.
Then, an ODI variable will read the date in the "yellow datastore table".
I hope the last value will not generate an error.1 person found this helpful
If it goes well, add a filter in the interface loading your file : DATASTORE_ALIAS.C2 IS NOT NULL.
It will ensure that your last value will not be loaded.