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

What is a grid in Informatica?

1119

---

What are data-driven sessions?

1261

---

How many numbers of sessions can one group in batches?

1101

---

What are the static cache and dynamic cache in informatica?

1245

---

What is a snowflake schema?

1047

---

Enlist the advantages of informatica.

1099

---

What are the different versions of informatica?

1337

---

Define update strategy?

1319

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1714

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10322

---

 Informatica Checkpoints

3378

---

Why sorter is an active transformation?

1252

---

Explain sql transformation in script mode examples in informatica

1211

---

How to call shell scripts from informatica?

1043

---

What are active and passive transformations?

1134

---