What are the components of Informatica? And what is the purpose of each?
Answer / Jaideep Shrivastava
The components of Informatica include PowerCenter, PowerDesigner, PowerExchange, and Data Services. PowerCenter is used for data integration and transformation, PowerDesigner is used for modeling and reverse engineering databases, PowerExchange is used for integrating data from non-Informatica sources, and Data Services is used for real-time data integration.
| Is This Answer Correct ? | 0 Yes | 0 No |
how do u tune queries?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
What are the Differences between connected and unconnected lookup?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
What is a sorter transformation?
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
In joiner, how to load Master table in Target?
What are the types of data warehouses?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
How can we integrate different flat file data in a single mapping and with in a single execution
What is the status code in stored procedure transformation?
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...