DSXchange

I tried to replace a space with an empty string and it let me replace and when I did a rtrim and then found the length it gave me the right length of the value in the column which makes me guess it should be a space. replace(colname, ' ','')

Thanks,
dsuser

We did load a table in DB2 using a DB2 Enterprise Stage fetching data from a Sybase source. There were a couple of columns with the char datatype. When the data gets loaded and I try to retrieve the data from the table I see all the char columns have been padded with spaces. And I'm not able to do a...

Can someone give me an apt example of the usage of rexec command. I would like to know in which scenario an rexec command can be used and how. And any other additional info reg the use of rexec command.

Thanks in advance,
dsuser

Hi,

I'd like to know if a look up to a ORAOCI stage will be faster or a look up to the Hash File(for about 20,000 records) will be faster with Pre-Load File to Memory option disabled.And Why???

Thanks,
dsuser

Hi, I have a table with almost 20 million records. Several jobs require to have this table as a lookup. But except for one job all other jobs require only a subset of records from this table. Is it good to create one hash file for the entire 25 million and use the same in all jobs. Or is it better t...

Hi,

Can someone throw some light on calling a shell script(execsh/rexec)(to call a PL/SQL Script in a remote Oracle Server) from Datastage.

Note: The Datastage Engine and the Oracle Server(the target db) are not on the same box.

Thanks,
dsuser

Hi

Can anyone explain about how slowly changing dimensions are implemented in the DW design. And how to implement surrogate keys.

Any help really appreciated.

Thanks much,
dsuser

Hi

I would like to know more about using MetaRecon and Integrity.
I do not have access to the tool. Can anybody tell me a good source (Material on the web or books or if anybody can send me some .pdf)of information on MetaRecon and Integrity.
I really appreciate the help.

Thanks much,
dsuser

Hi Can somebody explain to me the steps involved in extracting data from a SAP R/3 system and loading it on to a Oracle 9i Database. Is there any material available for this. I do not have the Extract PACK I would just like to have an idea as to how to perform this task. Any help appreciated. Thanks...

Hi Ray

ThankYou for your prompt response. I appreciate that. It was of great help.

Can you also give me a scenario where we can use the sort stage in server jobs.

How do we create Surrogate Keys?

Thanks much,
DataStage User

Hi When I try to give an input to a merge stage in a Server job it does not accept saying Stage cannot accept inputs. Can someone explain how to implement a Merge Stage. Can Merge stage take tables/sequential files as input. Also another question on Sort. Where do I specify the sort condition say I ...

Hi I'm just learning DataStage.I have a few questions Can somebody help me on that. 1. Is the SAP Extract pack with Datastage XE 6.0 sufficient to extract data from an SAP R/3 database. Or do we need any other tool like Power connect which is used for Informatica SAP integration. If SAP Extract pack...