Interested to Buy Any Domain ? << Click Here >> for more details...
diff between OLTP and OLAP?
what TOP-DOWN and BOTTOM-UP Approach? which is best?
what are Star Schema and Snow Flake Schema?
- 2 Answers
- 7085 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 8686865797
OLTP databases are highly Normalized relational databases & OLAP databases are highly De normalized.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can you explain engine tier in information server?
How one source columns or rows to be loaded in to two different tables?
how many rows sorted in sort stage by default in server jobs
Describe routines in datastage? Enlist various types of routines.
What are the partitioning techniques available in link partitioner?
options available in sequence job to run,validate?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is the project in datastage?
Differentiate between validated and Compiled in the Datastage?
Why do we use link partitioner and link collector in datastage?
What is datastage engine?
what is repositery?
Can you explain how could anyone drop the index before loading the data in target in datastage?
in oracle target stage when we use load option and when we use upsert option?
Which algorithm you used for your hashfile?
