835 reputation
1917
bio website chopeen.blogspot.com
location Poland
age
visits member for 3 years, 3 months
seen yesterday

SQL Server → .NET → SharePoint → Informatica PowerCenter

Twitter | LinkedIn | Last.fm


Jan
30
comment How to resolve red invalid icon for Informatica mapping
When you validate the mapping, are there any errors in the Validate tab of the output window (at the bottom)?
Jan
3
awarded  Yearling
Nov
22
comment Datamodel design for multiple roles, country access
You are modelling a data warehouse, right? The employee dimension should be denormalized into a single flattened dimension table. kimballgroup.com/2008/10/27/maintaining-dimension-hierarchies
May
23
awarded  Constituent
May
22
comment data warehouse construction from mdf and ldf file via etl
If you want to learn the tools, just use any database or a flat file or an Excel spreadsheet as a source.
May
22
comment data warehouse construction from mdf and ldf file via etl
If you already have a data warehouse database (i.e. AdventureWorksDW2012), why do you need an ETL tool? What do you want to achieve with it?
May
14
awarded  Caucus
Apr
11
awarded  Popular Question
Mar
15
awarded  Nice Answer
Feb
10
awarded  Famous Question
Jan
28
awarded  Informed
Jan
22
comment Is there a standard way to replace codes with values from a lookup table for reporting or analytics?
@MichaelMcGowan Yes, this is how it's called in PowerCenter. Other ETL tools may use different names.
Jan
21
revised Is there a standard way to replace codes with values from a lookup table for reporting or analytics?
added an image
Jan
21
answered Is there a standard way to replace codes with values from a lookup table for reporting or analytics?
Jan
3
awarded  Yearling
Dec
6
awarded  Notable Question
Jul
20
awarded  Organizer
Jul
20
revised ETL import more dimensions from only 1 column
edited tags
Jul
20
revised ETL import more dimensions from only 1 column
edited tags
Jun
21
revised Informatica Source Qualifier not working from Windows ODBC data source (system DSN) from Excel xlsx file
added article "VBScript to Convert Excel to CSV"