Answer Posted / megha bagaria

Drill up is when you are drilling lower level data to the upper level to check for the aggregated value where as drill down is when you are drilling from higher level to lower level to check if the distributed lower level values are correct or not when aggregated at the upper level.

Thanks and Best regards,
------------------------------------------------------------
Megha Bagaria | InfoCepts Technologies Pvt Ltd
------------------------------------------------------------

Difference between Target-based loading and constraint-based loading?

1042

---

where to store informatica rejected data?

1140

---

What is session task and command task?

1399

---

generate date / time dimension in informatica

1164

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1693

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

2005

---

What are the different clients of powercenter?

1117

---

Can we create a Integration service without a Repository service and vice versa?

1260

---

What are the types of caches in lookup? Explain them.

1014

---

Explain Dataware house architecture .how data flow from intial to end?

2650

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2126

---

What is rank transformation?

1037

---

Define mapping and session?

1092

---

How to use pmcmd utility command?

1077

---

What is the meaning of up gradation of repository?

2056

---