|
| 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 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. ... In a Flat File source there r Null as well as Blank values .If u r doing the profiling for that source ,how do u gete counts for the Null and Blank separately instead of getting them as one countThanksManish View Question | Asked by : MAnish 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 (8) | Asked by : Adi Hi,Can you please tell me whether Informatica 7.1.1 powercenter version can be installed on windows XP profesional. Iam trying to install both client and server on the same machine.But when Iam trying to create a system DSN from Source Analyzer menu, the application gets terminated it self.Please advise me if it should work.Thanks, Read Answers (4) | Asked by : Suneel Addala 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 (4) | 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
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
