Please Help Members By Posting Answers For Below Questions
I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
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?
diff b/w dwh & data mart
diff b/w star schema & snow flake schema
diff b/w fact table & dimension table
what are the contents in requirement specification
what are the docs needed for testing
draw ur proj architecture
what is Forward,Reverse and Re_engineering?
what is session partitioning?
Can u access a repository created in previous version of
Identifying the bottlenecks in various components of
Informatica and resolving them.
what is the use of structures?how many nodes can u create in a
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?
what is the difference between cardinality and Nullability?
what are the session parameters? How do u set them?
what are the reporting tools and difference between them?
how does the server recongnise the source and target
databases.Elaborate on this
what are the data sources extracted from logistics cockpit in
sap bw project and what is the requirement for it ?
where are the log files generally stored.Can you change the
path of the file.what can the path be?