Data Warehousing Community Forum
January 17, 2019, 11:14:09 am

Pages: [1] 2 3 ... 10
 1 
 on: January 07, 2019, 02:06:18 am 
Started by DaniMathis - Last post by DaniMathis
Przepierzenia oddalone dobrze przydzielaj_ si_ na nierównego typu bariery równie_ ju_ci konfabulacje plastikowe na plot rzadko furt_ ze sztachetek.

Here is my blog post; p_oty i ogrodzenia

 2 
 on: January 07, 2019, 01:01:27 am 
Started by BridgettPp - Last post by BridgettPp
Przepierzenia odleg_e genialnie nadaj_ si_ na niekoherentnego idea_u por_cze tamte ba nieprawdy plastikowe na plot czasami furtk_ ze sztachetek.

my site - ogrodzenia sztachetowe

 3 
 on: January 02, 2019, 06:08:54 pm 
Started by Lianamelissa - Last post by Lianamelissa
Hello,

I have to develop java code to interact with Informatica MDM tool for the following:

Implement beforeOpen(CustomizableBDDObject ob) method of IOpenOperationPlugin with a custom java code to lookup an attribute of a child object. BDDConfig.xml :

<subjectArea name="Subjectname" ...>
<primaryObject ...></primaryObject>
 ...
<one2ManyChild...name="Childname"..>
<layout..>
<column.... columnUid="ChildTablename|ColumnType"...>
<column.... columnUid="ChildTablename|ColumnValue"...>
..
</one2ManyChild>
I checked multiple Informatica Support videos but can't come to appropriate solution.

Need to call an SQLServer Scalar function from my java code and use the returned value in my code. I am concerned about hardcoding credentials in the code + how to use different DB connection properties based on the deployed environment? Will Informatica internally handles DB connection properties?

Thank you.

 4 
 on: December 28, 2018, 01:31:47 am 
Started by TylerBiden - Last post by TylerBiden
If you would like to take a great deal from this article then you have to apply such methods to your won weblog.

 5 
 on: December 26, 2018, 11:14:26 am 
Started by sjobs12@yahoo.com - Last post by sjobs12@yahoo.com
I have a star schema data warehouse. In dimension table T1, I have a BK (BK1) and several data columns (Col1, Col2 and Col3). Business wants to add two more columns (ColX and ColY) to the table for their use which are not part of the dimension. All the data columns are part of Type 2 SCD except these two columns. I am of the opinion that these two columns should not be part of Type 2 SCD for this dimension table as they are not part of the dimension. Any thoughts?

 6 
 on: December 17, 2018, 01:26:57 pm 
Started by TaniaHayni - Last post by TaniaHayni
Hello i am kavin, its my first occasion to commenting anyplace, when i read this article i thought i could also make comment due to this good article.

Feel free to surf to my web site :: Free Download Best Seller Book

 7 
 on: December 10, 2018, 08:05:06 pm 
Started by frankdegraaf82 - Last post by frankdegraaf82
Hello

I work for a non-profit organization. Our organization has a lot of different data sources / databases. In order to make all this data excisable for users we want to build a central DWH where the data is uniformed.
Our databases are all local and not in the cloud. Currently because of the different databases it is impossible for users to easily combine the data.

On advise, we have choses for a variant of the Kimball method. This is, we extract all the data from the different individual data sources to a central ‘data-store’, this is build with the use of SQL server. The ‘data-store’ also maintains the history of all the data from the individual databases. This means if a record is added or changed the old line will be closed with an end date and a new line will be added with the new data. This way we can track our historic data.

The idea is to transfer all this data to a central DWH where the data is combined through business rules to uniform data. That make it accessible for users.

The question is do you know if there is tooling for automating the writhing of the coding to fill the DWH on given metadata?

Because we are a non profit organization we cannot buy really expensive tooling, due to our limited budget we have to be smart.

Can anybody point us into the right direction?

Thanks a lot!

 8 
 on: December 10, 2018, 08:04:38 pm 
Started by frankdegraaf82 - Last post by frankdegraaf82
Hello

I work for a non-profit organization. Our organization has a lot of different data sources / databases. In order to make all this data excisable for users we want to build a central DWH where the data is uniformed.
Our databases are all local and not in the cloud. Currently because of the different databases it is impossible for users to easily combine the data.

On advise, we have choses for a variant of the Kimball method. This is, we extract all the data from the different individual data sources to a central ‘data-store’, this is build with the use of SQL server. The ‘data-store’ also maintains the history of all the data from the individual databases. This means if a record is added or changed the old line will be closed with an end date and a new line will be added with the new data. This way we can track our historic data.

The idea is to transfer all this data to a central DWH where the data is combined through business rules to uniform data. That make it accessible for users.

The question is do you know if there is tooling for automating the writhing of the coding to fill the DWH on given metadata?

Because we are a non profit organization we cannot buy really expensive tooling, due to our limited budget we have to be smart.

Can anybody point us into the right direction?

Thanks a lot!

 9 
 on: December 08, 2018, 08:36:57 pm 
Started by ShanonPres - Last post by ShanonPres
You reported it fantastically.

 10 
 on: December 08, 2018, 10:54:41 am 
Started by KristianMc - Last post by KristianMc
Cheers! Numerous data!

Pages: [1] 2 3 ... 10