Interested to Buy Any Domain ? << Click Here >> for more details...
we have to use order by,where,having we to implement sql query
- 1 Answers
- 5244 Views
- Satyam, I also Faced
- E-Mail Answers
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 |
Can you access a repository created in previous version of Informatica?
How are indexes created after completing the load process?
What are the different transaction levels available in transaction control transformation?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
what is scd?
How will u find weather dimension table is big in size of a fact table?
What is Code Page Compatibility?
I want load the data into target with out 1st and last record.
Name the different lookup cache(s)?
How might you approve all mappings in the archive all the while?
what is the difference between lookupoveride and joiner?
Explain how to import oracle sequence into informatica?
Teradata 
