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.

What is difference macros and prompts?

2280

---

What are the different types of join operations?

986

---

What is the use of dimensional modeling in data warehousing?

965

---

What are the other names given to data warehousing?

1078

---

Explain where do we use semi and non additive facts?

1006

---

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5640

---

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1075

---

What is a data profile?

959

---

What are the types of dimensional modeling?

1041

---

Compare cold fusion with other programming languages?

992

---

What is data warehouse architecture?

1030

---

What is a fact, dimension, measure?

1177

---

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1018

---

What is data type of the surrogate key?

992

---

What needs to be done when the database is shutdown?

1013

---