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.
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?
Give a way in which u can implement a real time scenario
where data in a table is changing and u need to look up data
from it.How will u configure the look up transform for this
purpose?
what are Lookup caches options? Including persistent caches.
34
how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
27
how can i text accracy of ETL migration? i am very new to
data warehousing. we are writing ETL scripts using
SCRIPELLA tool. how can i test the correctness of data.
and we are generating reports using pentaho . is there any
easy way to test the pentaho. how can test these ETL
scripts written in scriptella?
thanks in advance
59
how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?
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?
38
Identifying the bottlenecks in various components of
Informatica and resolving them.
30
Difference between flat files and relational sources?
105
what is the difference between cardinality and Nullability?
39
what is data modeling?
47
Two different admin users created for repository
are________and_________.
36
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?
64
what is Forward,Reverse and Re_engineering?
33
how would u estimate the size of Lookup transform data and
index cache?
34
how do u decide whether u need to do aggregations at
database level or at Informatica level?
33
Can u access a repository created in previous version of
Informatica?
20
what is the meant by Normalization and de-normalization?
58
what types of repositories we can create in informatica?
in real time in which type of repository we will work on?
32
Where can i get informatica certification Exam dumps and
details? please forward it to emailid: krisboppana@yahoo.com
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?
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
