Recent content by Variation180

This is prabably a dumb question and I'm prabably overlooking the obvious, but.... I need to format a number to a string format of "0000000.00". I have to have 7 characters to the left of the decimal and 2 to the right. I would do this in oracle with to_char(mynumbervalue,'0000000.00')...

You will not be able to use the trigger if you are using an append or direct load option. You can call the oracle sequence by creating a function in oracle to call it. Then you can call the function with a stored procedure transformation. Sorry for the confusion.

For our systems we would call the sequence from a trigger on the table. We however, have many processes hitting our tables at the same time (i.e. informatica, plsql and vitria). This way, regardless of what process we are using, the sequence generator is called by the table on insert or...

Are there any limitations to the number of transformations that can be in a mapping? I'm using v5.1 to aggregate 300 million records by partition as follows: 1. Source Qualifier I'm using sql overide to aggregate based on table partition. Each partition returns approximatly 12 million...

Our company is currently in the process of testing for upgrade to version 6 (or 7 now that it has been released). It may be 6 months before we can begin to use it. The initial load for 2 years of data is 300 million rows to the source table. I am writing back the aggregate id's to the source...

I'm using 4.7 to aggregate data from a table that is 24 million rows to an aggregate table that is approximatly 11 million rows. The first mapping does the aggregation and I have a second mapping that writes back the aggregate_id from the aggregate table to all the source records that make up...