Answer Posted / chenna
DSS(Decission support system) which helps to take decission
for the top executive people andbusiness manegements. it
generally based on
historical data(datawarhouse).
OLTP IS Online trasnaction processing,
OLTP contain curent data.
and it also maintains day to day transactios.
OLTP is a operational data.
| Is This Answer Correct ? | 13 Yes | 7 No |
Post New Answer View All Answers
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Explain what is power center repository?
Explain what are the various file formats involved in reportnet?
What is difference between query studio and report studio?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what is partitioning? What are the types of partitioning?
What is cfapplication tag?
What is dimension modeling?
Explain what is the metadata extension?
What is the function of etl when used in data warehousing?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What we will do with the universe for faster process?
Explain the difference between filter and conditin?
Explain what are the advantages and disadvantages of reporting directly against the database?
