DSXchange

Database: DB2 UDB Datastage: 7.5 AIX We have 3 fact tables (50 Million rows in each) in our datamart (EXACTLY SAME LAYOUT) which is being populated through Datastage job. Those 3 tables are then used to create VIEW and Business Objects XI is being used to create reports from that VIEW along with oth...

I have 4 DB2-UDB tables with exactly same layout. The data from all those 4 tables are to be moved to a single new table which will have the same layout as other 4 tables. What transform to use to Merge the 4 transformers and then send the one transformer to taget database? Table1--->Transformer1> -...

My guess would be the jobs would be put in a Sequencer and will be scheduled.

We first design out ETL job in TEST and then move to PROD. Most of our jobs uses parameters, most commonly TEST PROD InputFileName : Employee.txt ProdEmp.txt InputFilepath : /local/inputfiles/ /local/prodinputfiles/ OutputFileName : Emplyeeout.txt ProEmp.txt OutputFilepath :/local/outputfiles/ /loca...

Regardless of what ETL Tool one uses, if ETL code is generating one DELETE statement per row to be deleted, it always a database overhead...In most cases when that ETL code runs and it starts firing multiple delete statements, databases server is bogged down by the number of SQL statements.....I hav...

Hello folks, I have a sequencer job that consists of more than one jobs. Now in the first job, I need to pass a parameter. When the sequencer runs, it should take the first parameter and calculate a second parameter (second parameter is generated dynamically from database). After the second value (p...

Hello, I am new to datastage and need help on this issue. I have two sets of ETL jobs. - One that does the initial load for all the facts and dimensions by clearing the tables and - Other than does only inserts and updates. INITAL LOAD: This runs just for the first time. Before this job run, I run a...

First of all, many thanks to everyone here who took time to reply. Let me try to explain what's going on. There is one separate job that does a CLEAN insert into all dimension and facts tables. This job is run ONLY THE FIRST TIME. Before this job runs, it run a RESETKEY job that makes all the counte...

I used different methods and this seems to work fine. Instead of checking for NULLS I am checking if it returns any Values or not. I REPLACED IsNull(LookupProdCodes.ProdCode) with Len(Trim(LookupProdCodes.ProdCode))=0 for INSERT Len(Trim(LookupProdCodes.ProdCode))>0 for UPDATES It works!!! Thanks fo...

Hello friends, I desperately need quick help on this: This is the error I am getting "One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1&q...

OK, here is what I am doing step by step (1) Get ProductKey and ProductCode from Target Table (Only Distinct values) (2) Sending it to a HASH file through a transformer after removing any spaces using TRIM for both ProductKey and ProductCode. ProductCode is defined as "KEY" (3) Get the Val...

DataStage Version: 5.2 I have a CSV file that contains data (Both old as well as new). I need to UPDATE the existing records and INSERT the NEW records. Below is my CSV Data ProdCode Name Type 90 Shirts U 91 Pants T 92 Shoes M 93 Tie K I am creating a HASH file from the DB2 table and making "Pr...