we have to use order by,where,having we to implement sql query
Answer Posted / 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
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Can u generate reports in Informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Enlist the differences between database and data warehouse.
Write the unconnected lookup syntax and how to return more than one column.
What are different types of transformations available in informatica?
What are junk dimensions?
What do you understand by a term domain?
Explain what are the different types of transformation available in informatica.
What is a rank transform?
What are the conditions needed to improve the performance of informatica aggregator transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to elaborate powercenter integration service?