DSXchange

AFTER CLICKING OK ON THAT MESSAGE IT GIVES ME ANOTHER MESSAGE "UNABLE TO RETURN AN ATTACHED JOB"
BOTH ARE DATASTAGE REPOSITORY INTERFACE MESSAGES.

Error while creating job Error on CREATE.FILE command (creating file "RT_CONFIG8118" as type30.ymkdbfile:cannot create file RT_CONFIG8118yunable to create operating system file "RT_config8118" yxxx processing cannot continueyxxx)

Hi ,
I am getting this error while loading fact table
FACT_LOAD_FINAL_vrp_posn..Dynamic_RDBMS_47: ORA-00904: "TNT_ASSET_ACCT_SID": invalid identifier

TNT_ASSET_ACCT_SID is a column
i donno the reason please suggest
thanx

Hi, Iam trying to load a fact table. One of the transformation rule states that I do a look up on two tables which are other than the "source" and pull out field(SID) and load it in the fact table(without any lookup from the source). For that I did a lookup on those two tables and pulled ...

Hi, Iam trying to load a fact table. One of the transformation rule states that I do a look up on two tables which are other than the "source" and pull out field(SID) and load it in the fact table(without any lookup from the source). For that I did a lookup on those two tables and pulled o...

hi, I am trying to load fact table.One lookup hash file contains two fields one of them is key field but no lookup is done on this hash file its a direct move to the target for both fields .But the key field becomes red in the transformer stage and gives compilation errors. So I unchecked the key fi...

Hi ,
I got this error while compiling


ERROR COMPILING GENERATED SUBROUTINE FOR STAGE LINKNAME.TRANSFORMERNAME.

and it points to the transformer stage.
Please suggest.

Hi ,
I would like to know what update action I should select while loading data into data base when data already exist should not be deleted and we are running jobs parallely to load data into the database.

Is it update existing or insert new rows?

Thanx.

Hi ,
I would like to know is it possible to do a lookup on the fields of two look up hash files as I am trying to drag and drop the field but it remains red.I have made them as keys too and tried but they still remain red.Please suggest.
Thanx

Hi,
I would like to have a routine that will return a monthenddate for a given date.date is in yyyy-mm-dd format.
Thanx .

Hi,
I would like to know what type of errors I can encounter apart from reject records from business rules when loading data from staging to datawarehouse.
Thanx.

Hi,
Can anyone tell me the transformation/mapping concepts as I need to document.
Thanx

Hi ,
I am trying to insert 0000-00-00.00.00.00.000000 into oracle database but's its giving me an error "invalid number".
Thanx

Hi,

When I login to my administrator I see a message

DSR.ADMIN:Failed to open file(other than access)-developer.

When I click ok everything works fine.

Please suggest how to get rid of this warning.
Thanx

Hi, I have an issue reading mainframe file whose format is H,date(2006-07-07)..... D,............................. D,.................... . . T,1234,.................. H-header record D-data record T-trailer record I am using same metadata to read all the records using CFF stage to convert ebcidic ...