Answer Posted / nagaraju bhatraju
Target Types are File, Relational and ERP. Latest Answer :
PowerCenter can load data into the following targets:
Relational. Oracle, Sybase, Sybase IQ, Informix, IBM DB2,
Microsoft SQL Server, and Teradata. File. Fixed and
delimited flat file and XML. Application. You can purchase
additional PowerCenter Connect ...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is unit testing?tell me proceedure
What is a dimensional model?
What is an expression transformation in informatica?
How you can differentiate between connected lookup and unconnected lookup?
On which transformations you created partitions in your project?
Why do we need informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Repository user profiles
how to load dimension table and fact table. plz tell me the steps.
What are multi-group transformations?
What are active and passive transformations?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
According to his methodology what all you need before you build a datawarehouse
Enlist the advantages of informatica.
How do you change a non-reusable transformation to reusable transformation?