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
View mobile version
Subscribe to:
Post Comments (Atom)
Popular Posts
For Variables
The naming convention for variables is: v_ 1. A variable name should be easy to read and convey the purpose of the variable. This help...
What is use of Shortcuts in informatica?
If we copy source definaltions or target definations or mapplets from Shared folder to any other folders that will become a shortcut. Let’s...
What is Staging area why we need it in DWH?
If target and source databases are different and target table volume is high it contains some millions of records in this scenario without...
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...
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...
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...
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-...
What are theTypes of Triggers ?
This section describes the different types of triggers: Row Triggers and Statement Triggers BEFORE and AFTER Triggers INSTEA...
Why we need source qualifier?
Simply it performs select statement. Select statement fetches the data in the form of row. Source qualifier will select the data from the s...
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