DSXchange

Its not poping up any messages (ActiveX or any other ). Simply opening the html file.

There is typo in the subject of this post. It is metadata.

Hi all,

When I generate report on a server job from DS Designer, it is showing most of the job Info but missing parameter names / Input column names / output column names / derived columns / passthrough columns. Is there anyway to show those in the report.

Thanks
VS

Hi,

I am getting a strange error while selecting jobs in version control project.

Here is the error message "Unable to read record. Error: 30001".

Thanks
VS

Thanks all

Hi, I have a comma delimited flat file with variable columns (not sure about the number of columns in each record, i.e., each record may atleast have 90 columns or more). I have to extract the file and use first 90 columns for our process. We may require rest of the columns for future process. I app...

Is DataStage Version control tool available with PeopleSoft EPM suite.

Thanks to all

I would like to clear the RT_LOG file for a specified date/range of logs.

For example clear the previous all logs, except today's log from RT_LOG.

Is there anywayt to do this.

Thanks

Hi All,

I need to pull column name(s) along with the associated data for look-up column name(s) with a static look-up table and get corresponding match ID to populate source data and look-up ID to target table.

I appreciate your inputs.

Thanks
VS

How can we automize the process of Excel to CSV/TXT conversion, prior to ETL/DataStage process. (with no human intervension)

I appreciate your help.

Thanks

Hi Arun, Do you have one source file arriving into staging file-system? Or 40 source files from 40 sources? What is the frequency of source file(s)? If you have n-number of source files arriving daily/weekly/monthly/yearly/etc., keep track of those incoming files into a status file (through a script...

Hi Bala, Do you mean lookup dimension table(s) using OCI stage(s)? What is the volume of your dimension table(s)? Best practice in performing lookup is, using Hashed Files. By using Hashed Files, you always write lookup data into Hashed Files, where as with OCI stages ( OCI SQL / user-defined SQL) y...

Do you have Index for the Where clause field(s)?

Move that template to a common shared folder of that project, on DataStage Server.