 Related Questions 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. ... 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. 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 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
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
