Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to improve the performance of a session using sorter transformation?
What is a mapplet/worklet in informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How you know when to use a static cache and dynamic cache in lookup transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Different sorts of metadata that stores in the storage facility?
As union transformation gives UNION ALL output, how you will get the UNION output?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to load a Dimension ? and how to load a fact table?
Explain sessions. Explain how batches are used to combine executions?
What is confirmed fact in dataware housing?
Explain scd type 3 through mapping.
How can you define user defied event?
Explain the informatica workflow?
