Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

---

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

---

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

Explain the difference between a data warehouse and a data mart?

0 Answers  

---

what is size of u r database?

0 Answers  

---

In a sequential batch can you run the session if previous session fails?

4 Answers  

---

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

---