skip to main
|
skip to sidebar
Search This Blog
Contributors
Kushanoor
flyingcolors
Followers of flyingcolors99
your turn hear
Friday, March 12, 2010
TCL
TCL and Tk Toolkit ByJohn K. Ousterhout
Datamining for B.Tech, MAC and M.Tech
Datamining By HAn and Kamber
Common Warehouse Metamodel
Common Warehouse Metamodel ------ John Poole, Dan Chang, Douglas Tolbert, and David Mellor
Data Warehousing Guide
Oracle9i Data Warehousing Guide ------ Oracle
DataWarehousingFundamentals
DataWarehousingFundamentals
Thursday, March 11, 2010
Building the Data Warehouse
Building the Data Warehouse (3E) ------ W.H.Innmon
The Data Warehouse Toolkit
The Data Warehouse Toolkit BY Ralph Kimball Margy Ross
Sunday, March 7, 2010
SQL Queries on Emp table
Click Hear To get SQL Queries on EMP, DEPT tables
Newer Posts
Home
Subscribe to:
Posts (Atom)
Popular Posts
Installing Informatica PowerCenter In windows 7
Hi All installing the informatica power center on Windows 7( problems resolved) befoere clicking the setup right click on the setup-...
Simple senario with solution
I have the source table is Number 1 1 2 3 3 4 Target_unique Target_Duplicates 2 ...
Informatica Real Time Scenerios
Split the non-key columns to separate tables with key column in both Scenario 2: Split the non-key columns to separate t...
Dimensional Model
1. Facts 2. Fact Table 3. Dimension 4. Dimension Table
Naming Convention Quick Reference
Object Type Syntax Folder XXX_ Mapping m_fXY_ZZZ_ _x.x Session s_fXY_ZZZ_ _x.x Batch b_ Source Definition Target Definition Aggreg...
Have you done any Performance tuning in informatica?
1) Yes, One of my mapping was taking 3-4 hours to process 40 millions rows into staging table we don’t have any transformation inside ...
DataWarehousingFundamentals
DataWarehousingFundamentals
What is the difference between a primary key and a surrogate key?
A primary key is a special constraint on a column or set of columns. A primary key constraint ensures that the column(s) so designated hav...
How to Process multiple flat files to single target table through informatica if all files are same structure?
We can process all flat files through one mapping and one session using list file. First we need to create list file using unix script f...
What is your tuning approach if SQL query taking long time? Or how do u tune SQL query ?
If query taking long time then First will run the query in Explain Plan, The explain plan process stores data in the PLAN_TABLE. it will ...
Total Pageviews
Blog Archive
►
2013
(1)
►
09/22 - 09/29
(1)
►
2011
(201)
►
08/28 - 09/04
(1)
►
07/17 - 07/24
(2)
►
07/10 - 07/17
(1)
►
06/26 - 07/03
(38)
►
06/19 - 06/26
(26)
►
06/12 - 06/19
(123)
►
05/01 - 05/08
(1)
►
01/09 - 01/16
(2)
►
01/02 - 01/09
(7)
▼
2010
(29)
►
08/29 - 09/05
(1)
►
08/08 - 08/15
(5)
►
05/23 - 05/30
(1)
►
04/04 - 04/11
(4)
►
03/21 - 03/28
(10)
▼
03/07 - 03/14
(8)
TCL
Datamining for B.Tech, MAC and M.Tech
Common Warehouse Metamodel
Data Warehousing Guide
DataWarehousingFundamentals
Building the Data Warehouse
The Data Warehouse Toolkit
SQL Queries on Emp table