Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
1967how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
5 16126can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
1 4086
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
What is abap? What are idocs?
what make u disappointmnets in u r career
what are the cubes developed in a sap bw project and what is the requirement for developing it?
What do you understand by active and passive transformations?
What is partitioning? Explain different types of partitioning?
how do u implement configuration management in Informatica?
What is etl tool in hadoop?
What are the names of the layers in etl?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What are the key benefits of ETL Testing?
SCD2 will work on only dimension tables as well as fact Table?
Compare ETL & Manual development?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?