diff between OLTP and OLAP?
what TOP-DOWN and BOTTOM-UP Approach? which is best?
what are Star Schema and Snow Flake Schema?
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
Where do you see different stages in the designer?
How the ipc stage work?
What is the differentiate between data file and descriptor file?
What is the use of hoursfromtime() function in transformer stage in datastage?
options available in sequence job to run,validate?
Can you explain tagbatch restructure operator?
What is the difference between datastage and informatica?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
client know skid info?
sed,awk,head
Why we use surrogate key?
What are the different types of lookups in datastage?
What is a merge in datastage?
What is "fatal error/rdbms code 3996" error?
Name the different types of Lookups in Datastage?