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
can u give example for factless fact table
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
differences between service based and product based?
How do you load unique records into one target table and duplicate records into a different target table?
What do you understand by SOA of Informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Write the unconnected lookup syntax and how to return more than one column.
What is aggregate cache in aggregator transformation?
What are the designer tools for creating transformations?
What are the new features of informatica 9.x developer?
What is the way to execute pl/sql script using informatica mapping?
What are the static cache and dynamic cache in informatica?
What are the different versions of informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Can we get 1st record through Informatica(without sequence number).
