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
What is rank transformation?
What is the procedure for creating independent data marts from informatica 7.1?
What is the use of source qualifier?
What do think which one is the better joiner or look up?
What is the difference between a repository server and a powerhouse?
Write the different tools in the workflow manager?
What is the need of etl tools?
What could be the possible resons of locks by user?
Explain in detail about scd type 1 through mapping.
what is SDLC way of code development?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the difference between informatica 7.0 and 8.0?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain about cumulative Sum or moving sum?
What is the status code in stored procedure transformation?