DSXchange

Hi all,

I am using XML Input stage reading the XML files from Folder stage. I want to use the Filename column of the Folder stage to my output column.
That means, i need to record which data comes from which XML file. How this can be done?

Thanks in advance..

Regards,
Angel

ArndW wrote:That could be the cause. You need to execute the following:

• CREATE ROLE DSXE; GRANT SELECT on sys.dba_extents to DSXE; GRANT SELECT on sys.dba_data_files to DSXE; GRANT SELECT on sys.dba_tab_ ...

Thanks a lot for your response. I will try it and let you know.

Hi all, I have a job with source and target stages are Oracle enterprise. The job was running fine without the partition table property. Since it had taken much time, to improve the performance, i have given the partition table property. Now i have got the following error: "Connect failed: Orac...

Hi all, I have got error in OCI stage as "The provided insert statement did not prepare correctly;please verify that your statement is correct;" My job design is as follows: My source and target tables are 10g tables. Source OCI stage extracts data and the source data is spitted based on 7...

Not enough information. What logic are you using in your SCD stage? What is it about the third node (#2) that caused the failure to be there? What data volumes are involved? How big (number of row ... Hi Ray, Thanks for your response. I am using TYPE 1 logic. Not only the third node, all the nodes ...

Hi,

I am getting the following error in my SCD stage.

"SCD,2: Failure during execution of operator logic. SCD,2: Fatal Error: Index too large"

Kindly help me to solve this..

The SCD stage takes care of all of that, by using memory-mapped copies of the dimension tables. Read Vincent's blog or the IBM collateral to see how it's done. ... Hi Ray, Thank you very much for your response. Now I am trying to solve it by SCD stage. My requirement is as follows: "If dimensi...

ray.wurlod wrote:The obvious question is "why not just use a SELECT"? ...

Hi Ray,

Thanks for your reply.
I am migrating the OWB code into Datastage 8. My requirement is to use the existing oracle procedures. The existing procedure will be doing the SCD logic Type 1 or type 2.

Hi, I am calling a stored procedure which will be executed for each row in the source in my job. Based on the return values of this procedure, the records will be inserted/updated into the target table. I have a situation like the link from procedure to target should work on row by row. That is, the...

ray.wurlod wrote:Check that your Source parameter is being passed correctly (look in the "job starting" event in the job log). ...

Thanks for your reply.

Yes Ray. In the log for Data source and user name, correct values are passed. For password, it is encrypted and passed.

Hi all, I have given environmental varaiables for data source, user name and password in the stored procedure stage. I am getting the error "Stored_Procedure_75,0: Error: ORA-12154: TNS:could not resolve the connect identifier specified" If i use hard-coded values for data source, user nam...

Hi,
How to call an oracle procedure from datastage routine?
I am searching this forum for this, but still need help.

Thanks in advance..

chulett wrote:That's just a matter of setting the Lookup Failure property to 'Continue', is it not? ...

Thanks Craig!

Hi,

Is it possible to do left outer join with lookup stage in 8x. If so, please let me know the possible ways.

Thanks in advance.

ray.wurlod wrote:Of course pretty much any default behaviour in DataStage BASIC can be overridden by $OPTIONS compiler directives.

In this case, to have the -1 element add a new empty field/value/subvalue, specif ...

Thanks all.