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 does reusable transformation mean?

676


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1780


What is the maplet?

622


What is primary and backup node?

702


what is INFORMATICA TESTING process

1844






What are multi-group transformations?

566


How to elaborate tracing level?

687


if we have a delimiters at unwanted places in a flat file how can we over come those.

1572


Explain the tuning lookup transformation - informatica

615


How to create the source and target database connections in server manager?

634


How do you manage the Parameter files while migrating your data from one environment to another environment?

555


Which means the first record should come as last record and last record should come as first record and load into the target file?

610


Explain transaction control transformation in informatica

763


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1539


Global and Local shortcuts. Advantages.

1472