 Related Questions There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)? Hi,1.Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregator what is the order that we have to group by?Thanks,Arpita. Read Answers (3) | Asked by : Arpita Latest Answer : We can update the target table, by using the update override in target definition. it will update based on non key columns. ... Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data. 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 Hi all,Could anyone tell me why session fails when running a workflow? I don't see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.ThanksKamalnayan Read Answers (4) | Asked by : Kamalnayan Maramraj Tags : RDBMS 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 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)
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0