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

What are the performance considerations when working with aggregator transformation?

0 Answers  

---

How can you access the remote source into your session?

1 Answers  

---

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

---

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

---

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

---

Explain the use of aggregator cache file?

0 Answers  

---

What is the difference between router and filter?

0 Answers  

---

What is a unit Testing?

1 Answers  

---

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

---

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---