Hot answers tagged

7

Date dimensions are pretty standard in a data warehouse, and are highly recommended by Kimball as most facts tie to a date. Typically, the key is an integer. It can be a meaningless surrogate key, or it can be a "smart" key where the integer is in the form yyyymmdd; e.g., the key for August 2, 2014 would be 20140802. Date dimensions provide a set of ...


2

Parametrize your report and make sure that your query is parametrized too. You can test your parametrized report inside the report designer. Then use Kettle/PDI to feed the parameters to your report step, and once you produce the file, rename it or move it to the correct spot. Running several smaller reports also allows you to run multiple reports in ...


2

SQL Server does not allow updates the IDENTITY column value regardless of application technology. One way to perform such a migration is to switch data into a table with identical schema (except for the IDENTITY property), perform the update, and then SWITCH back into the main table. CREATE TABLE dbo.TableWithIdentity( IdentityColumn int IDENTITY NOT ...


2

Noob error! Pentaho "hops" are not sequential; they will all run simultaneously. The correct way to handle this type of process - read data, write data, and then manipulate the data in SQL - is to put the read/write in a transformation by itself, and then put that transformation into a job with the SQL procedure(s) following the transformation.


2

The ASYNC_NETWORK_IO wait type indicates that SQL Server has finished doing the work it has been asked to do and is waiting for the consuming application to confirm that it has received all of the data. This is normally due to the application consuming the data in an inefficient manner. The classic is if the application is processing the data row by row. ...


2

JDBC Driver that Neo4J provides are for Cypher queries ( which are select only). There are no inserts , updates or delete. You will have to adopt some other means like .. exporting rdbms stuff to csv and importing csv to Neo4J.


1

Just use the select values step. Convert the data type to a string and specify the mask: yyyyMMdd Note the mask is a java simpleDateFormat and you can google that for more details. It is case SENSITIVE. The mask in PDI is only used for 3 things: Converting from the real data type to a string Display purposes when previewing data Any other time you ...


1

With the help of the author of the script i used (sqlserver2pgsql) we realized it was a (new) issue with how Kettle handled parallel output table truncates. https://github.com/dalibo/sqlserver2pgsql/issues/57#issuecomment-282675275 What happened was, and the reason i only lacked even hundreds of data, that the output job in some cases did run truncate ...


1

you can do this with help of MDX Custom filer on filter option when we generated report for cube. there you write query regaring dimension table and fact table with help of select measures.[attribute] on rows from cube name where conditon apply . and so on...


1

You could do that. I'm thinking something along the lines of having an active and inactive date on your fact table for each product for each customer. Then you could mark a previous product with an inactive date. This should allow you to query it for date ranges that are include a specific date to get what their product list was for a specific point in time....


1

maybe it's too late but I faced to this problem and I could solve it. At first you need to add Table Input tool for getting records from MySQL then you can add execute SQL script from Scripting tool. create your transformation from Table input to Execute SQL Script. then Get fields and check mark : Execute for each row? Execute as a single Statement then ...


Only top voted, non community-wiki answers of a minimum length are eligible