Answer Posted / kishore

Import to test file:-
--------------------
bcp "SELECT ProcContent FROM <DBName>.dbo.NewProc order by
ID" queryout C:\NewProc.sql -c -S <ServerName> -T

If we can run(dos prompt) above statement in set of records
are store into c:\newproc.sql file.

Export from File:-
-----------------
BULK INSERT myTestCharData FROM 'C:\myTestCharData-c.Dat'
WITH ( DATAFILETYPE='char', FIELDTERMINATOR=',');

Explain how are the dimension tables designed?

993

---

Explain er diagram?

942

---

Explain a linked cube?

914

---

what are relationships?

993

---

Explain what are the various methods of getting incremental records or delta records from the source systems?

922

---

Explain functional dependency?

1041

---

What are steps we have to follow in designing the userfriendly universe?

931

---

Explain what is the limit to the number of sources and targets you can have in a mapping?

956

---

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

885

---

Is there any difference in testing database and data ware housing?

2707

---

How can we load the time dimension?

1144

---

Explain is olap databases are called decision support system true/false?

962

---

What is Sequence clustering algorithm?

1979

---

How can we run the graph? What is the procedure for that?

894

---

Explain piconet?

906

---