skip to main
|
skip to sidebar
Search This Blog
Contributors
Kushanoor
flyingcolors
Followers of flyingcolors99
your turn hear
Thursday, June 16, 2011
Logical Design Example
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Popular Posts
Simple senario with solution
I have the source table is Number 1 1 2 3 3 4 Target_unique Target_Duplicates 2 ...
What is Factless Fact Table?
Factless fact table captures the many-to-many relationships between dimensions, but contains no numeric or textual facts. They are often u...
What is De Generated Dimension?
An item that is in the fact table but is stripped off of its description, because the description belongs in dimension table, is referred to...
ENGINE MANAGEMENT
M ANAGING THE E NGINE The development and production engines shall be managed by the Informatica support Team. Information regar...
What is Ment By Indexes ?
1 . Bitmap indexes are most appropriate for columns having low distinct values—such as GENDER, MARITAL_STATUS, and RELATION. This ass...
Accumulating Fact Table
An accumulating fact table is where all of the dimensional attributes are not available at the time of creation and the dimensions that are...
Code Page overview ?
A code page contains the encoding to specify characters in a set of one or more languages. An encoding is the assignment of a number to a c...
(no title)
There is a source table containing 2 columns Col1 and Col2 with data as follows: Col1 Col2 a l b p a m a n b q x y Design ...
What is the difference between joiner and lookup
Joiner Lookup In joiner on multiple matches it will return all matching records. In lookup it will return ei...
What is the difference between view and materialized view ?
View Materialized view A view has a logical existence. It does not contain data. A materialized view has a ...
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)
What is Data Cardinality?
What is the difference between Informatica 7.0 and...
In which circumstances that informatica server cre...
What is the method of loading 5 flat files of havi...
What are mapping parameters and variables in which...
In a sequential batch can you run the session if p...
What type of metadata is stored in repository?
What does #! /bin/sh mean in a shell script?
Below line is the first line of the script ?
If file exists then send email with attachment ?
Searching for files ?
What is the CMD gives total no of users logged in ...
How to find all processes that are running ?
How to create zero byte file ?
How to create zero byte file ?
How to display alternative rows in a table ?
How to find the Top sal ?
How to find 2 nd highest Sal ?
How to find Top 5 salaries ?
How to find the Dense rank ?
A query to assign the Ranks
Write the query to transpose rows into columns.
How to remove duplicates in the table ?
How to get duplicate rows from the table ?
What are theTypes of Triggers ?
Explain about Triggers ?
what is ment by Packages ?
What are the differences between stored procedures...
What is your tuning approach if SQL query taking l...
Explain Plan ?
Why hints Require ?
What is Ment By Indexes ?
What is the difference between sub-query & co-rela...
Explain MERGE Statement in SQL ?
Differences between where clause and having clause ?
How to Use where and having clauses in Query ?
Difference between Rowid and Rownum ?
What is the Difference between Delete, Truncate an...
What is the difference between view and materializ...
How Can we Get dept wise max sal along with empnam...
Inline view ?
What’s the difference between View and Materialize...
Outer Join
Cross Join
Natural Join
Self Join
Non-Equi Join
Equi Join/Inner Join
What is the difference between a primary key and a...
What is a surrogate key?
What is ODS (Operational Data Sources) ?
What is Staging area why we need it in DWH?
Type 3 Slowly Changing Dimension
Type 2 Slowly Changing Dimension
Type 1 Slowly Changing Dimension
Physical Design Example
Logical Design Example
Simple data model
The differences between a logical data model and p...
Physical Data Modeling
Logical Data Model
Conceptual Data Model
What is Data modeling ?
What is De Generated Dimension?
What is Junk Dimension?
What is Conformed Dimension?
What is slowly Changing Dimension?
Dimensional Model
What is Granularity?
Types of facts?
What is Factless Fact Table?
What is Fact Table?
What is Fact ?
What is the difference between snow flake and star...
What is a snowflake schema?
What is a star schema?
What is a Schema?
What is the difference between a data warehouse an...
What is a DataMart?
What is a Data Warehouse?
What is BI ?
Informatica Testing
Performance tuning in Informatica
Naming Convention Quick Reference
Naming Conventions and usage of Transformations
Failure Notification
Data Loading from Flat Files
Transformation Specifications
General Development Guidelines
How to load cumulative salary in to target ?
If we want to run 2 workflow one after another(how...
How to populate file name to target while loading ...
How to Process multiple flat files to single targe...
How to send Unique (Distinct) records into One tar...
How to concatenate row data through informatica ?
How to do Dymanic File generation in Informatica ?
Workflow Execution Process
Difference between 7.x and 8.x --- Part2
Difference between 7.x and 8.x
What is the Parameter file Format
►
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)
No comments:
Post a Comment