 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 ... In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i 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? Read Answers (9) | Asked by : reddy 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 (5) | 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 Can anyone tell me , How to understand the use of transformations in informatica mapping for particular target port? Read Answers (9) | Asked by : Adi 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? Read Answers (6) | Asked by : Reddy Latest Answer : Hi,Export your mapping to XML file and then Import it to Client machine . I am assuming here the client and your system as same version and environment for Informatica.-Sphurti. ... Read Answers (1) | Asked by : uday I want to send the excle sheet as a souce to another excel sheet as target.so i created a mapping with souce excel sheet to target sexcel sheet correctly. but i'm faling to enter the correct connection string in establishing relatonal connections for type ODBC .My ODBC data source is XL(Microsoft Excel Driver(*.xls)). tell me what is the connection string for ODBC (Like oracle is the conn string for Oracle services) I have a datatype as varchar2 in source table and when I load the data in the target table it is mapped to nclob datatype.when I run the mapping , there are junk values in my target table which has nclob datatype.Could you please let me know how to solve the issue.Thanks in advance
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
