I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.Please, any one have a solution to this problem(I installed Informatica 7.1 on WINDOWS XP Home Edition, Oracle 10g)Thanks a lot.nagesh
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 ...
Latest Answer : In Session properties SELECT treat source rows as UPDATE
In Target properties of session SELECT Insert, Update works like it updates if row is existing or Insert if the row is not existing. ...
I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.i hav windows server 2003 OSPlease, any one have a solution to this problem
In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?
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?
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,
Can anyone tell me , How to understand the use of transformations in informatica mapping for particular target port?
In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and wich transformations we r using?and explain logic?