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)?
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. ...
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,
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?
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
When i start the informatica services for loading in workflow manager, the informatica services shows runing status but when i see the properties service, status has stoped. With-in sec services has stoped when i was trying to start the services for informatica, how can i overcome this problem?
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?
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)
