select count(1) from emp? what is the o/p?

Answer Posted / chandu

count(1) means it will count based on 1st column in the
select statement

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the basic requirements to join two sources in a source qualifier transformation using default join?

609


What all are steps in up gradation of Informatica server?

617


What can we do to improve the performance of informatica aggregator transformation?

616


What is meant by lookup transformation? Explain the types of lookup transformation?

566


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1577






What is a dimensional model?

582


how we can load rejected record's at run time?(not through bad files)

1907


Clarify the aggregator change?

592


What is decode in static cache?

586


How to generate or load values in to the target table based on a column value using informatica etl tool.

606


Different circumstance which drives informatica server to expel records?

549


What are data-driven sessions?

713


Explain the features of connected and unconnected lookup.

543


How do you promote a non-reusable transformation to reusable transformation?

658


Explain what are the different types of transformation available in informatica.

570