Can we change Dynamic to Static or Persistent cache? If so
what happens?
what is degenerated dimension?
What is Index Caches size?
In update strategy target table or flat file which gives more performance ? why?
Can yoU use the maping parameters or variables created in one maping into another maping?
What is an MDDB? What is the difference between MDDBs and RDBMSs?
how can we use sorter transformation in joins?
when we use dynamic lookup,if condition matches what will be the o/p?
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
How to update source definition?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
in a table it has 200 rows the query is select 150 from tablename.whats the output
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?