DSXchange

yes i am able to view the data from sequential file but i couldn't be able to insert to table (ODBC sql server)

hi sura, My job design is seq file.........>tfm........>odbc(sql) in sequential file all the columns and datatypes and length is same as it is target ODBC. I am just extracting records from seq file and loaded the data as it is in odbc. Do have to check the file records and their length and datatype...

AAC_PARIS_PROCESS..Transformer_10.DSLink33: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO TBL_SRC_PARIS_EXTRACT(RPT_DT, CHILD_FUND_ID, CHILD_FUND_CATG, CHILD_FUND_SHRT_NM, SERIES_ID, SERIES_CATG, SERIES_TYP, PARENT_FUND_ID, PARENT_FUND_CATG, ACCT_INVST, AI_CNTR_TYP, PARIS_CNTR_NUM,...

hi ray,

Can you explain a little bit more.

hi sura,

its slowly changing dimension type 2

hi, i am using SCD type 2 i just want to know that how to know about the current data and old data. As far as i know in dimupdate tab we can give expirtion date which shows old data and current indicator represents current data. Is there any other by which we can know which one is old and new. Pleas...

can you please give other warnings or errors

have you tried to change the name of column

did you check the default timestamp in your project

hi chullet,

you mean to say that i just use @OUTROWNUM in constraint of both the links and it give me the 500 record in first link and next 500 in second link.

Plese advice me on this

hi,

can you please explain how can i use the system varible @OUTROWNUM in transformer i just want to know how i can i give condition.

can you send some syntax that i can use either in constraint or stage variable.

advice me

hi i have 1000 records in a file with column name salary and i want first 500 records in first output link and next 500 records in other output link My job design sequential file...........xfm...............>first sequential file ...................> second sequentil file Can anybody advice me on th...

hi, My job design is as follows. odbc(DB2) (header record)......................................... . . . . . . odbc(db2) (detail record)..........column imprt ...........funnel.............>seq file . . . odbc(db2) . (trailer record)................................................ All odbc's are fu...

hi all,

thanks for giving information i got the solution

Hi My input Datatype for column CYC_DT is date so i have to change to string using the following code as mentioned by Ravi. If IsNull(CYC_DT) then SetNull() else (convert("-","",DateToString((CYC_DT))) Also i have to take care of null first as code shows and then covert to output...