How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

how can u load the data in time dimension?

3 Answers  

---

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

---

What is target update override

2 Answers   CTS,

---

How are indexes created after completing the load process?

0 Answers  

---

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers   ACS,

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

How to go to the older version for a mapping?

0 Answers  

---

What is the function of look up transformation?

0 Answers  

---

Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers  

---

What are the types of lookup transformation?

0 Answers   Informatica,

---