Please Help Members By Posting Answers For Below Questions
please tell me any easy ways of testing the Data warehouse
project. In my project we are not using any tools for ETL.
we are writing scripts in SCRIPTELLA.
And we using Pentaho tool for Reporting
How can i test all these. please tell me ASAP.
thanks in adavance
what is pmrep command?
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.
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.
what are the reports created in mm and sd side using sap bw in
a project? name some of them and explain the requirement?
what are the concerns of OLTP and DSS systems?
how do u extract data from different data sources explain
with an example?
1.Identify and discuss the problems which are occurred
during data quality verification for the single-source and
2.Testing has very important role in DWH. In ETL testing
phase, how can we perform the integration testing and
3.What are the perquisites of system testing and regression
testing in ETL phase?
Difference between flat files and relational sources?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions
D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and
surrogate keys K1,K2,K3,K4
(a) write a sql statement to populate Fact table F1
(b) Design a mapping in Informatica for loading of fact
What is Data Vault???
Just Completed the informatica Certification ,for Dumps please email me on email@example.com i will send it to you
what do u do when DB time takes more?in sap bi
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?
Hi my name is kuldeep singh, i have finished my B.E in
computer science and engg in 2008. I have worked with
accenture for 17 months and because of family problem i
left the job in dec 2009.. i was in data ware housing
right now i am working in a BPO as technicla support
executive,, i want to move to IT again, please suggest me
what shuld i do? its been 1 year gap and i am not able to
get into IT...please suggest me ...should i go for
informatica certification will that help me to get inot IT.
please give ur suggestion..my E mail is is