What is up date strategy and what are th options for update
strategy?
Answer Posted / guest
update strategy is a transformation which helps to flag a
record either to update ,delete,insert,reject
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What are the various transformation available?
Explain what is the difference between view filter and report filter?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What are the types of SCD?
What is the difference between filter and lookup transformation?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Explain the difference between dw and bi?
Can you state some of the innovations throughout history?
What is batch processing?
What is Sequence clustering algorithm?
Start a batches with in a batch?
Is there any difference in testing database and data ware housing?
Explain what are the advantages and disadvantages of reporting directly against the database?