DSXchange

Thanks for reply
100 records is just an example i told...records are in millions from source ..
i am fetching all delta records like new inserted records and updated one(no-key value changes for known keys)..and also deleted records

unique key is not surrogate key its natural primary key

not provided any thing(any field which has update time stamp/system gen time stamp) to identify new rows...there is unique key... looks like i have to fetch everything from source every time ..but still looking for alternatives i tried left joining source with target but even it also do the same(fet...

thanks for reply ray
i am using DS8.7 using Change Capture stage to capture the delta records
using odbc_connector as source and oracle_connector as target

Hi my source is Sql server and Target oracle i am trying to design a job to load Delta records ..but the source doesn't have any date fields ..so whenever i am loading data source fetching all the records...is there any way that i can fetch latest records from source in other words today i loaded 10...

Thank's every one
my problem is resolved .now they are sending file with no header's

HI
i am getting a flat file with too many headers

ex

empno empname
1 krish
2 chris
empno empname
3 raghu
eampno empname
4 sri

like this
can any one please tell me how to remove those headers in Ds job

initially we don't have start_utc_dttm and End_utc_dttm in database table . after they changed table definition my job running good.

my bad

problem is resolved

Thanks for reply pandeesh

i am inerting in bulk mode

this is after sql
thanks

my job looks like

sequential file---->transformer---->TDconnector

can any one help me out
Thanks

hi i am loading teradata table using Teradata connector i am getting following fatel error table_TGT: [IIS-CONN-TERA-005004] RDBMS code 3810: SP_STAGE:Column/Parameter 'col' does not exist. SQL statement: call (CC_TeraConnection::execute, file CC_TeraConnection.cpp, line 2,640) can any one help me o...

Thanks ray
thanks for your reply

my architect asked me to analyse the way to minimise the impact on source db
that's why i am curious about it

hi all i am new to cdc my company bought license for infosphere cdc my environment is infosphere cdc for oracle v6.3.13(using redo) source is oracle 10g on aix 5.3 64 bit here i have to capture changes to flatfile actually here i want to know is how to minimise the impact on source database(oracle 1...