what is a parameter when and where do u them when does the
value will be created. Designing time, run time. If u don't
create parameter what will happen?
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 ?
147
Can u access a repository created in previous version of
Informatica?
205
A mapping contains
source table S_Time(stat_year,end_year)
target table TIM_DIM(date,day,month,year,quarter)
stored procedure transformation: A procedure has two
parameters I_end_year and output parameter as O_date ,day ,
month, year, quarter, If this session is running, how many
rows will be available in the target and why?
95
architural difference between 7.1 workflow monitor and 8.1
workflow monitor.
how would u estimate the size of Aggregator transform data
and index cache?
118
can be used COM component in Informatica ?
143
what is the use of server?
101
how do u set partition points in the mapping?
149
what is pmrep command?
300
what is dynamic insert?
103
how do u implement configuration management in Informatica?
342
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?
144
what is the difference steps for data modeling?
91
list and discuss two approaches for updation of target table
in Informatica and how they are different.
92
what are the data modeling tools you have used?(polaris)