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
What is the benefit of partitioning a session?
What is the difference between Active and Passive transformation?
What is aggregate cache in aggregator transformation?
How do you take back up of repository?
What are data-driven sessions?
Explain what is informatica metadata and where is it stored?
What differs when we choose the sorted input for aggregator transformation?
What is the need of an ETL tool?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How can we improve session performance in aggregator transformation?
Explain in detail scd type 2 through mapping.
Briefly explain the aggregator transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain what transformation and how many are there in informatica?