DSXchange

Hi,

can anyone please let me know how to change the file dictionary in this case.

Thanks

Hi, Yes my input data has already contain a decimal place container, Can you please explain me how to make this change , i loaded some data into the Hashed file from a DB2UDB table . Hashed file is created in the project directory , Then i imported the metadata from the table definitions using the u...

Hi all, I am trying to use a universe stage to do a range lookup , this is for small amount of data , what i did was i loaded the data into a hashed file and then i am accessing through a universe stage , i have a decimal value which is 11,4 in the hashed file ,but i changed it to numeric and the da...

Ray, I got it woking , i am able to pick up the value in the query now the only thing is the terminator. job ran 4 times loaded 4 records in a sample file everything is fine but the sequencer aborted after the fourth run saying Error calling DSSetParam(delimiter), code=-4 [ParamValue/Limitvalue is n...

Ray, Which of these should i use in the parameter for my query SELECT DISTINCT main.I_CURR FROM DLROB.SMRATRN main, (select i_curr, max(i_dlr_dim) i_dlr_dim from dlrob.smrdlrd group by i_curr having count (*) > 1 ) temp where main.i_curr = temp.i_curr and main.i_curr=#delimiter# in the source stage ...

Hi I tried doing this with the datastage job and for one delaer it took about two minutes to update every record for that dealer .But when i tried it with around 1500 delaers job is in pending remote request stage in the database and its taking time , as the users are querying on the transaction tab...

Sure i will and update you guys on monday

Thanks

Yes Exactly i was asking the same thing if i can do the same thing because i have only 5000 distinct dealers i can extract all the distinct delaers from my fact table and also look uo with a file from dealer table with all the dealers and the max dealer dim for that dealer. Only thing i wanted to ch...

Hi Guys, I have a requirement to update one of the keys in the fact table.its a part of combo key in the table. Now this key is a dimension key and this dimension table used to have a slowly changing dimension till last year . now it was taken out due to the business requirements. the deal is to fix...

hi all, I am using a odbc stage to access oracle database in one of my job. It was working fine in production. Recently we added new jobs to the same project and tried to run the whole project for testing and found an error in accessing odbc stage. I checked the ODBC connections it is working fine. ...

hi all, I am using a odbc stage to access oracle database in one of my job. It was working fine in production. Recently we added new jobs to the same project and tried to run the whole project for testing and found an error in accessing odbc stage. I checked the ODBC connections it is working fine. ...

If I mention 4000 through out the process, at remove duplicate sorting is using scratch space for 4000 which we cannot afford So we left the length as empty throught out the job. Just in the oci stage for load, we specify it as 4000 length varchar. Hi all, We are using a column as varchar without sp...

Error which i get is as follows When checking operator: When binding output schema variable "outrec": When binding output interface field "LOOKUP_STRING" to field "LOOKUP_STRING": Implicit conversion from source type "string" to result type "string[max=40...

Length in target table is 4000

narasimha wrote:What is the length of this column specified in your target oracle table?

Hi all, We are using a column as varchar without specifying any length. But while loading in the oracle table we specify as 4000 length in oci stage. Records with length more than 110 are going to reject link with a warning in log which specify a future chance of truncation. I tried using modify sta...