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')...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.