skip to main
|
skip to sidebar
Search This Blog
Contributors
Kushanoor
flyingcolors
Followers of flyingcolors99
your turn hear
Sunday, June 26, 2011
Mappings
The naming convention for mappings which relate to specific systems could be like this: m_
_
_
Example:m_trex_rps_create_transaction_stf_format
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 ...
informatica course
informatica online course
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 ...
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...
STARTING A NEW PROJECT
Project Initialization A mail has to be sent to the Informatica Support team before the start of any project. The mail should ...
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...
ENGINE MANAGEMENT
M ANAGING THE E NGINE The development and production engines shall be managed by the Informatica support Team. Information regar...
NAMING CONVENTIONS FOR TRANSFORMATIONS
seq_DIM_PRODUCT Source Qualifier Transformation ‘sq_’+ table name If the source qualifier is defined ...
What is Data Cardinality?
Cardinality is the term used in database relations to denote the occurrences of data on either side of the relation There are 3 basic ...
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)
If i had source like unique & duplicate records li...
I have a scenario like - how can i load 1st recor...
In EMP table, for those emp whose Hiredate is same...
write a sql query to get the id and how many times...
Test Functions
Special Functions
Date Functions
Conversion Functions
Character Functions
Conformed facts
Conformed dimensions
Non Additive Facts
Semi Additive Facts
Additive Facts
Snapshot Facts
Transaction Grain
Factless Facts
Accumulating Fact Table
Submit Command
ENGINE MANAGEMENT
TRANSITION OF PROJECTS FOR SUPPORT
CHANGES TO AN EXISTING PROJECT
MIGRATION TO PRODUCTION
DEVELOPMENT AND TESTING PROCESS
STARTING A NEW PROJECT
Parsing Procedure
Parsing Data Overview
Miscellaneous standards
Performance improvement related standards
Server Variables
Log and Bad files
Parameter files
For Variables
Sessions
Workflows
Mapplets
Mappings
NAMING CONVENTIONS FOR TRANSFORMATIONS
►
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)
No comments:
Post a Comment