Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ankur saini er.ankur861@gmail.
count(1) means it will count based on the first columnin
the table ..say first column is a_id and data ia
a_id a_nm
1 a
2 b
3 c
4 d
? e
so here count(1) will be =4 where as count(*) =5
so count(1) give the count for column 1 excluding nulls
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the scenario which compels informatica server to reject files?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are active transformations.
Differentiate between router and filter transformation?
Global and Local shortcuts. Advantages.
What is session task and command task?
How many transformations can be used in mapplets.
Do you find any difficulty while working with flat files as source and target?
What is lookup change?
What is option by which we can run all the sessions in a batch simultaneously?
What are the popular informatica products?
Can you use flat files in Mapplets.
How to differentiate between the active and passive transformations?
What are the prerequisite tasks to achieve the session partition?
Have you worked with/created Parameter file
