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 aggregator transformation in informatica?
What is the use of source qualifier?
Informatica settings are available in which file?
Briefly explain the aggregator transformation?
What are the restrictions of union transformation?
What are active transformations.
How you can differentiate between connected lookup and unconnected lookup?
How do you use reject loader.
can you please explain me pre session and post session options?
Explian the Process of deployment groups in informatica
How to update or delete the rows in a target, which do not have key fields?
Can you generate sequence numbers without using the sequence generator transformation?
What is meant by a domain?
whats the logic to load the lower level of granularity of data to fact table.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
