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

How many repositories can be created in informatica?

1 Answers  

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  

Which is the t/r that builts only single cache memory?

0 Answers  

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

what is difference between COM & DCOM?

1 Answers   Satyam,

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

how many session run unix environment what command using ?

1 Answers   HCL,

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,