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 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

what is incremental data aggregation?

3 Answers   IBM,

---

What is the status code?

1 Answers  

---

What are mapping parametres and variables in informatica?

6 Answers   TCS,

---

There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  

---

What is a standalone command task?

0 Answers  

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---

In Which scenario did u used Incremental loading?

2 Answers  

---

What are the different caches used in informatica?

3 Answers   UST,

---

Define sessions in informatica etl?

0 Answers  

---