can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
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?
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 ?
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.
When do we analyze the tables?
what is SMP AND MPP?
Identifying the bottlenecks in various components of Informatica and resolving them.
how would u estimate the size of Aggregator transform data and index cache?
what happens if the info.server doesn't find the session parameter in the parameter file?
What do you understand by the term ‘transformation’?
what is the use of structures?how many nodes can u create in a structure?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.