DSXchange

hi all; i have 26,000 input records. based on number of records, i need to genearte surroagte key sequence. . i am using keymgtgetnextvalue(%sequence name%), in sequence name i am giving input column totalnet assets which is unique for each row if it exists, when i run the same job first time it's s...

-------------------------------------------------------------------------------- hi T42; [Are you using APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL? Or are you using a specific field information to define NULL values from input sequential file? How do you identify whether the input data on a file is a n...

Hi all; i am loading data from falt file (tab seperated ) using sequential file stage to database table using odbc stage. in loading data from source to target, i need to do null checking on some fileds , if null those records are loaded in to reject file/table.i am using constraint to do this. i ha...

hi,

i am extracting tab delimited source file using sequential file stage. but in sequentail file out put ,under columns tab

columns names appearing as
filed001,
fileld002,

,,,,


filed047. it is not displaying actual column names, what might be the reason.

thanks

Hi all, i could not understabd my target ER model. my source is flat file (tab delimited) , there are 47 fields. from them 21(nsar 62a..... nsar 66 ) fields are manually populated into pri_asset type table as records), 18 fields are manually populated into investment_risk table as records. there are...

Hi Members; what is differnce between Hashes File stage and LookupStage. i know we use hashed file stage in server jobs, lookup stage in parallel jobs . i don't know exactly what is the function of above stages. i got job in datastge , and i am new to Datastage . as for my understanding from manuals...

hi to all, i am new to datatstage, i am working on datastage enterprise edition. input data contains fundname as one of the filed, in output i have to generate system generated identifier for based on fund name. how it is possible . i know that we have to generate surrogate key for each fundname, bu...

Hi every one,

i am new to datastage, we can schedule jobs using datastage director, then why do we use autosys as job scheduler in datastage

Hi every one, i am new to datastage , we are working on parallel extender we are loading flatfiles into relational tables(oracle) . after extracting using sequential file stage , using tarnsofrmer stage how we are going to test for null values for fields. is there any built in transform to check nul...

it is flatfile,and also we are using enterprise edition, thanks for ur help