when u connect the repository for the first time it asks you
for user name & password of repository and database both.But
subsequent times it asks only repository password. why?
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 ?
how do u estimate the depth of the session scheduling queue?
Where do u set the number of maximum concurrent sessions
that Informatica can run at a given time?
70
how do u decide whether u need to do aggregations at
database level or at Informatica level?
87
what are the concerns of OLTP and DSS systems?
95
what is the difference between cardinality and Nullability?
99
what is session partitioning?
78
what is the use of server manager?
103
when will use SQL override in a lookup transformation?
241
Is there any body who works on Pervasive Data Integrator
(previously Data Junction)? Is there any scope also?
241
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.
82
Two default user groups created in the repository
are____and_____.
241
A session S_MAP1 is in Repository A. while running the
session error message has displayed `server hot-ws270 is
connect to Repository B`.what does it mean?
126
where are the log files generally stored.Can you change the
path of the file.what can the path be?
124
what are the data modeling tools you have used?(polaris)
109
Difference between flat files and relational sources?
224
Can u access a repository created in previous version of
Informatica?
what is the meant by Normalization and de-normalization?
167
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?
136
what are the concerns of OLTP and DSS systems?
103
how would u estimate the size of Lookup transform data and
index cache?
108
can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.