Answer / chitti

U CAN TUNE U R QUERIES BY CREATING INDEXES ON COLUMNS,AND
ELIMINATING KEY CONSTRAINTS .AND ALSO GIVE SORTING IN SQL
ITSELF.

how do u tune queries?

1 Answers  

---

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

---

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

0 Answers   CTS,

---

Describe an informatica powercenter?

0 Answers  

---

Which transformation is needed while using the Cobol sources as source definitions?

0 Answers   Informatica,

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

---

Explain scd type 3 through mapping.

0 Answers  

---

Explain incremental aggregation in informatica

0 Answers   Informatica,

---

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

---

What are the components of workflow manager?

0 Answers  

---