 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 : We can update the target table, by using the update override in target definition. it will update based on non key columns. ... Suppose one flat file taking loading time of 3 hrs.How u can reduce that loading time to 1 hr.( No FTP, Not UNIX system to make parallel processing,No splitting file,and all servers and files and targets existing in same system) Read Answers (3) | Asked by : Jagadeesh When importing data through fixed-width wizard, how will u distinguish between different columns if the file is of multiple lines terminated by a \n character. Read Answers (1) | Asked by : raj You can download an IBM Book on Dimensional Modeling from the following link:http://www.redbooks.ibm.com/abstracts/sg247138.html?OpenThis is an excellent IBM Redbook on Data warehouse design and Dimensional Latest Answer : Guys,http://freedatawarehouse.com/tutorials/default.aspxCheers,Sithusithusithu@hotmil.com ... 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 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 (9) | Asked by : Adi
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
