Answer Posted / rahul sehgal

Control M Consist of Many Jobs that are use for :-

Enabiling the down AgentNode(CTMUENA*)

Pinging the down AgentNode(CTMUPNG*)

Disabiling any AgentNode(CTMUDIS*)

List Job which is use for checking availability or
unvailaibility for particular Server in Control M
CTMULST*
(Command that is use for this particular job is
ctm_agstat -LIST '*'| grep-i available|unavailable)

There are many other control M jobs that are use for
different-2 purposes.

Explain difference between view and materialized view?

1021

---

What is execution plan?

1258

---

Explain which columns go to the fact table and which columns go the dimension table?

968

---

Explain what is the extension of file to save template?

1018

---

What is analytical or analytic mean?

1188

---

Explain about core dimension,

1036

---

What is the difference between metadata and data dictionary?

1218

---

What are the different types of segments?

1035

---

What is called dimensional modelling?

1183

---

Explain the difference between filter and conditin?

1014

---

Explain what are the various file formats involved in reportnet?

1018

---

What are the various transformation available?

1059

---

Explain what is partitioning? What are the types of partitioning?

1011

---

What is the extension of file to save template?

1054

---

Explain some of modeling tools available in the market?

1023

---