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
How to partition the Session?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Which transformation is needed while using the Cobol sources as source definitions?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
what is mean by complex business rule ?
What happens when a session fails and you click on recover?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is the scenario which compels informatica server to reject files?
How to load data in informatica ?
can u any challenge your project?
What is the need for an etl tool?
can anyone suggest best free Talend data integration training online
Explain the etl program with few examples.
Under which circumstances, informatica server creates reject files?
