DSXchange

I agree that Pivot Stage can be used to Pivot one row into many rows. But, this is the otherway round. One column into many columns. Thanks. Hi, Can sombody tell me if there is a way i can change Column data to a row. Example... A file that has column data as shown below. This should be pivoted. &qu...

Hi, Can sombody tell me if there is a way i can change Column data to a row. Example... A file that has column data as shown below. This should be pivoted. "08/01/2002" "Requirement" "CDWP" "Corporate Data Warehouse" "Accounting Period Loan Unpaid Princip...

Hi, The Source file for my job is actually a file created from an XML Source file. The XML Source file contains Data in the Heirarchy of an Excel Workbook. That is, Sheet -> Row -> Column -> Data. The Output file from the XML source for one of the Sheets, looks like this. The First Column is Row, th...

Hi, I would like to know about, using MS Access as the Source/Target DB. MS Access DataBases are on my Local Machine. In DataStage, to get connectivity to MS Access Source/Target, i will be using ODBC Stage. But, i am not sure of ODBC Configuration requirements in Unix. I need some information about...

Hi, I would like to know about, using MS Access as the Source/Target DB. To get connectivity to MS Access Source/Target, i will be using ODBC Stage. But, i am not sure of ODBC Configuration requirements. I need some information about ODBC Configuration for MS Access and the setup procedures. Thanks.

hi, i created a server job with cff stage , a transformer stage and oracle bulk loader stage .The aim of the job is to read a fixed width sequential file and bulk load the fixed width file into a oracle table. All the necessary parameters were set in the oracle bulk loader stage with loadmethod set ...

Hi,
What are the major differences between DataStage Ver 4 and 6.

Hi,
I want to know the Tasks of a person who is a DataSTage Administrator for a Data Warehouse Implementation in an Organization.
Aditionally i want to know the things to be taken care of before and after upgrading from Ver 4 to 6.

Thanks.