s********1 发帖数: 3 | 1 我现在要load flat file 到sybase table
这个表比flat file多一个rundate 列
请问怎样在scripts里把这个rundate列也
加上 然后bcp到表里
还是我只能把其他列bcp,然后在表里再update
那个列?
thanks a lot for your suggestion. |
j*****n 发帖数: 1781 | 2 bcp to a staging table that has a rundate column with default value as
GETDATE. |
s********1 发帖数: 3 | 3 thanks for reply.
then how to cp from staging to final one?
【在 j*****n 的大作中提到】 : bcp to a staging table that has a rundate column with default value as : GETDATE.
|
j*****n 发帖数: 1781 | 4 now you got all you want in stating table...
insert into destinationTable
Select * from stagingTable
when you do ETL, staging table is a good practice for doing data massages.
【在 s********1 的大作中提到】 : thanks for reply. : then how to cp from staging to final one?
|
j*****n 发帖数: 1781 | 5 I haven't using sybase for years... so I can only give you the universal way
. I am sure there would a better way for using sybase ETL tool. such as in M
$ SQL Server, you could have a derived column to do so in SSIS without
sacrifice performance and storage space. |