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)
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.
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 ...
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,
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
Latest Answer : Hi,Export your mapping to XML file and then Import it to Client machine . I am assuming here the client and your system as same version and environment for Informatica.-Sphurti. ...
Latest Answer : we take source data from databae like oracle or any other database .. 1 st we take source data in import option in source section in desginer... ok thanks ...