![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions Latest Answer : Dimension Mapping: The mapping which uses target as one of the dimension is called dimension mapping, suppose a warehouse has 4dimension tables and 1 fact table that is a star schema of 4 dimensions we design 4 dimension mappings to load data into 4 dimensions ... The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use? Read Answers (4) | Asked by : Deshaireddy 1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file? Read Answers (4) | Asked by : pratyusha What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both? I am asked to create a detailed metadata about ,transformations used in perticular fact table mapping.How do i understand and create write up on what has happened to each port during each tranformations?By right click on port in target definition and choosing backward path , I could get complete path fot that port.Pls. adviseThanks, Read Answers (1) | Asked by : Adi Tags : Metadata Latest Answer : Dynamic cache - can be configured as connected lookup only. It does not support lookup on flat file. Can have only equality operator in lookup condition.Static cache - can be configured as connected as well as unconnected lookup. Supports lookup on flatfile. ... Read Answers (3) | Asked by : senthilkumarselvaraj Latest Answer : Essbase is a multidimensional DBMS and Hyperion performance suite is a set of BI tools. ... Read Answers (1) | Asked by : karthik mani Latest Answer : global repository in 7.1 versionnew cutom transformation,normalizer transformation added in 7.1 ... Read Answers (2) | Asked by : raj Where exactly dimension and fact tables are useful? Is it source or target?We are importing source directly from database and transforming and loading the data to target.Can anybody please send where they exactly it is useful? Read Answers (3) | Asked by : sree What is the difference between informatica7.1 and new version 8.1,what are the advantages in new version 8.1. Read Answers (1) | Asked by : amit (pcpl)
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||