Answer Posted / munni
count(1) will give the count of the numbr of records in the
table. count(1) is faster than count(*) since the count is
not based on all the fields.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the different lookup cache(s)?
According to his methodology what all you need before you build a datawarehouse
Explain Dataware house architecture .how data flow from intial to end?
what is unit testing?tell me proceedure
What are the uses of etl tools?
What are the main features of Oracle 8i with context to datawarehouse?
What does reusable transformation mean?
What are the new features of informatica 9.x developer?
Where can we find the throughput option in informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Define enterprise data warehousing?
Explain lookup transformation in informatica
How to update source definition?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?