-
RDBMS
Modern RDBMSs perfom the following functionc except ______________.
a) Force column values in one table to match any of the values in a column of another table
b) Automatically replicate data on another server
c) Automatically create new indexes based on query history
d) Prevent unauthorized users from accessing data at the firls level -
Max of Date using Aggregation
How to find Max and Min of date in aggregation ?
Input:
Empid start_date End_date Sal
1 2015-01-01 2015-12-31 1000
1 2016-01-01 2017-05-29 2000
2 2014-01-01 2015-12-31 1000
2 2016-01-01 2017-03-15 800
3 2011-01-01 2015-12-31 1000
3 2016-01-01 2017-05-10 1200
4 2016-01-01 2017-02-14 2000
Output_Should be like... -
Question about the design
Hello.
I am a programmer, VB .NET.
I have a Question about the design tools in this photo.
Whether the list box is used?or tree view?
What tools are used?
Thank you.
http://8pic.ir/images/33xmknxxknbl5sbrg3ci.jpg -
What is LLD and HLD ?
what is Low level document(LLD) and high level document(hld) and mapping document what they contain?
-
Quality center 10.0 version(save method is not working), while uploading attachments to quality center
The code below ,is for uploading attachments to quality center 10.00
Function UpLoadAttachmentToQC(FilePath)
Set ObjCurrentTest = QCUtil.CurrentTest.Attachments
Set ObjAttch = ObjCurrentTest.AddItem(Null)
ObjAttch.FileName = FilePath
ObjAttch.Type = 1
ObjAttch.Post
ObjAttch.Refresh
End Function
FilePath=”C:abc.vbs” -
Data Planning & Modeling
What are the major differences between the two approaches to data planning and modeling – enterprise modeling and view integration? Why do these two methodologies usually yield different results? In what ways does the existence of pre-packaged data models affect these approaches?
-
Data Validation Strategies for Data Mart
What are Data Validation Strategies for Data Mart?
-
Site Replication
How does replication takes place between two sites?
-
General flow for feasbility study
Outline the procedure for the feasbility study of building datawarehouse for a company.
-
-
Ans