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
Explain the pipeline partition with real time example?
tell me about your project functionality
What is deployment group?
what is informatica metadata?
What is the maplet?
what is $$$$?
What does refresh system mean, and what are its distinctive choice?
What are junk dimensions?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is the difference between informatics 7x and 8x and what is latest version?
Define the various join types of joiner transformation?
When do you use sql override in a lookup transformation?
Tell me about Propagate functions in informatica
How to join three sources using joiner? Explain though mapping flow.
What are the different types of transformation available in informatica.