Answer / chandu

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

Answer / munni

count(1) will give the count of the numbr of records in the
table. count(1) is faster than count(*) since the count is
not based on all the fields.

Answer / moorthy g

select count(1) from emp;

Count(1):
14
It will display how many records in emp table
Total 14 Records are there in my table.
Correct If I'm wrong
Regards,
Moorthy

Answer / guest

all emp count will be displayed

Answer / 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

What is the use of an aggregator cache file?

0 Answers  

Explain transaction control transformation in informatica

0 Answers   Informatica,

What are the methods for creating reusable transforamtions?

2 Answers  

What is joiner transformation?

0 Answers  

what is INFORMATICA TESTING process

0 Answers  

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers