Recent content by AshishVinny

How can I pass the location and Name of the flat file which is being used as the source of a mapping. What I did /tried: I assumed 2 variables $$SOURCE_DIR and $$SOURCE_FILE. In Workflow Manager, For Tasks or sessions, there is no place where u can go and define the variables/parameters. The...

Hi, Can I pass the values to these variables $SOURCE, $TARGET and $DBConnection_... as parameters from parameter file and how ???

1 Fact for analyzing the load types if there is a need for that... second fact for load quality analysis. U could have them merged into 1 fact if u can........

Krishnan, I believe u have two kind of changes to handle here. 1. Record updations - Time Variancy Problem 2. Business Relationship Expiration - Business Effectivity Problem. TIME VARIANCY SOLUTION -------------------------------- Keep 3 columns : DW_OPEN_DT, DW_CLOSE_DT, DW_CURRENT_IND ------...

Let me get back to u. I have the perfect solution for this. As I have implemented a EDW with the same problem.

Can u not identify the groups of load types on the basis of load patterns and try to convert this into a dimension which would not be rather not be dependent on daily transactions. ANyway the thumb rule is dimensions represent the entities and their attributes. It does not contain any...

WHat is the best way of representing a many-to-many relationships on multiple entities in DWH. Each entity is being converted into a dimension. The only transactions in the source application are about many-to-many relationships between entities in the source environment - ASSET Management...

Which database username/password to be used ?? I dont understand this.

Thanx !! Dave !!! It worked. SOmehow it was not creating the database. I went al=head and removed the entries for OUI as well and cleaned up the registry and it worked !! :) Ashish.

Hi, My laptop had Windows 2000 sitting on it with ORACLE 8i running on it. Recently I was forced to apply Service Pack 3 on it which screwed so many installations already running on my laptop including my ORACLE installation too !!! My Old ORACLE services stopped working. I downloaded ORacle...

I am working on a job which collects the rowcounts on a particular condition from many tables using multiple ORACLE Stages to read the rowcounts( Simluating a large Union Statement). I am using multiple streams/links ( For faster response) and writing them into one hash file. One of the...

I have a couple of jobs which balance the number of rows between ETL Source and target. If the source and target are not same then few jobs should fail with a appropriate message and few of them should give warning with a message. How to achieve this ???

I have been working on DataStage for few months now. Basically I have been designing simple jobs (its a BaseWareHouse with Sybase 11.5 as source and ORACLE 8i as Target) so far. As I was familiar with other ETl Tools like informatica, I have been able to manage so far but for complex activities...