What is SCD (Slowly Changing Dimensions)? What are its types?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQLServer Errors Interview Questions

In one table there is 10 records without id num,without primary key and it is not sorted then how to extract last 6 record from table?

4 Answers  


Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

0 Answers  


what is meant by write off and write on in sap?

5 Answers   Reliance Communications, Wipro,


I am experiencing an error failed to retrieve data from data base. it is an oracle table. Is there a limit on the number of fields that can be a report. My table has 321 fields and I do not have all of them in the report yet.

1 Answers  


hp asking for replication floppy to do reinstall 25254 server assistant

0 Answers  






today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

0 Answers  


What is Mutex error in Triggers?

0 Answers  


What are row constructors?

1 Answers  


write a database figure to implement the master detained relationship.

0 Answers  


i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

0 Answers   Investment Bank,


Difference between Bookmark lookup & RID lookup?

1 Answers  


What is the meaning of lock escalation and why/how to stop this?

0 Answers  


Categories