Answer / sehaj

IN A QUERY WE CAN USE ALL THE THREE....BUT USING WHERE N
HAVIN DOESN MEAN ANY SENSE...
IF WE USE GROUP BY WE CAN USE WHERE CLAUSE BEFORE GROUP BY
PORT...
AND IF WE USE GROUP BY WE CAN USE HAVING AFTER GROUP BY CLAUSE..
N GENERALLY ORDER BY CLAUSE IS ALWAYS WRITTEN AT THE END OF
THE QUERY

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---

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

3 Answers   TCS,

---

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

---

What is a joiner transformation and why it is an active one?

0 Answers  

---

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

---

Enlist the differences between database and data warehouse.

0 Answers  

---

what is update strategy transformation ?

7 Answers   TCS,

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

how many types transformations supported by sortedinput?

4 Answers  

---

What will be the approach?

0 Answers  

---