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

Which are the different editions of informatica powercenter that are available?

1023

---

Explain load alternative records / rows into multiple targets - informatica

1137

---

what is Active lock explain

2772

---

Why is sorter an active transformation?

1101

---

Enlist the various types of transformations.

1021

---

What is the use of source qualifier?

1115

---

Explain how to import oracle sequence into informatica?

990

---

What is native users?

1139

---

Explain the features of connected and unconnected lookup.

920

---

How to convert multiple rows to single row (multiple columns) in informatica

1366

---

How can we use batches?

1005

---

How to do the error handling of if ur source is flatfiles?

1948

---

What is the use of an aggregator cache file?

1181

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1774

---

What differs when we choose the sorted input for aggregator transformation?

1008

---