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 what is the extension of file to save template?

915

---

What is data analysis?

898

---

What are the tools available for etl?

927

---

What is the difference between filter and lookup transformation?

1023

---

What is the difference between power center and power mart?

965

---

What is data stream and data adaopter. Is it same are different? Explain?

915

---

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

879

---

What are target types on the server?

940

---

Give some difference between oltp and olap.

956

---

What is a view as it relates to system modeling?

936

---

Explain me what are conformed dimensions?

950

---

How to create prompts in report net?

939

---

What are the mapping paramaters and maping variables?

977

---

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

904

---

Where we use surrogate key explain with example?

1047

---