DSXchange

For testing I had created a job in which I have only the EMP_NO integer 38 null. The source is sequantial file, I had viewed the data and I can view it. I am using transformer, Here i am just mapping input to output. The target is Oracle stage,in that I am performing Write Method=LOAD, Write Mode=a...

Below is all the error in the log when we are bulk loading into SQLServer. Username,Pwd,tablename and the Server Name seem to be fine as we could load it using an ODBC stage.Please advice. SQL server OLEDB provider authorization failed. Failed to establish datasource connection. Seems like a proble...

You can change your NLS settings in Job Properties window or within each stage for a job. Let us know whats your current setting in there. The current setting is like this (as shown below). Default map for stages is Project default (ISO-8859-1) Default collation locale for stages is Project (OFF). ...

Hello, I am using oracle stage, I am using load. I am getting a warning when i run the job Warning:The NLS map <ISO-8859-1> specified may not be compatible with the character map specified in NLS_LANG. You may get unexpected results from your database . So kindly help me where should i perform the ...

Do connections using the Designer/Director/Manager also freeze? If so, then it is certainly a network connection related issue, otherwise it is the Administrator. Also, have you tried connecting from ... My best guess is that you might not be using the True Administrator id that has the access to r...

Hi, 1) How sorted i/p file increases the performence. 2) If size of the Master table and update table exceeds the RAM size, then what will happen , it leads to page fault error or not 1) Ray's explanation is a perfect reason why it improves performance. 2) Assuming the join is affecting the entire ...

We are running DataStage on AIX and when I try to view the data in a table connecting to DB2 Data base (through DB2 UDB object in my mapping), I get the following error : Error message : "dsloadlibrary: error in dlopen" I have added the ODBC connection in uvodbc.config in DataStage Project...