DSXchange

My job is seq file -> tx -> or db table. DSLink8.Eff_date looks like this 2/3/2009.I am trying to use stringtotimestamp function in the transformer.My time part in the timestamp can be default.I tried various combination as the sainath suggested but still i get the same warning. I am on 7.5.1a Than...

can you post the error you got when compiling in the test environment???

keep the data type as timestamp and select (micro seonds) in the extended property of the column... in you are doing transformation in the transformer(if you extracted the column as a string from db2) ..use the string to timestamp function like this.. StringToTimestamp(DSLink2.name(ex:2008-02-28 19:...

if you are coneverting from a string to a timestamp format with microseconds ..try palying around with changing the default timestamp format in the job properties -->defaults section

don't go with view data option in the seq file stage to check what is written to the file

what you see when you open the file on UNIX box, is what you have in the file...

or try this

when writing to seq file...set the property under field defaults -->null field value --> ""
and see

[quote="chulett"]Sheesh... posts so good they need to be repeated - [i]three times.[/i] Seriously, please start checking after you post and delete any duplicates, especially if it takes 'some time' to complete - that's pretty much a sure sign you'll have duplicate posts.[/quote] can you he...

duplicate post

duplicate post

thanks for your quick response.can you please elaborate about the first stage you have (oracle reference) what is that to do? also in the lookup stage I dont find any option for sparse lookup? can you please elaborate about the first stage you have (oracle reference) what is that to do?---- just to...

i agree....

i agree....

source | | | | Ora(Reference)-----Lkp-------Target ( Lkp type: sparse) (Read Method : User-Defined sql) (SQL Query : select sample_seq.nextval as seq_num from dual) on the Lkp stage map the field seq_num to the ouput field which is unique seq number on the target side

you want to use that DB sequence to create the unique number every time you run one particular job or you want to use that DB sequence in other jobs as well???

[quote="Nagaraj"]Properties info..

1. Drop output for copy= True
2. And the rest all are set to FALSE.[/quote]

please be more specific what do you mean by data getting added??

set "CLEAR" TO preserve partioning flag on TRANSFORMER