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

Is it possible to revert a global repository to local one and why?

1022

---

explain one complex mapping with logic? sales project?

6590

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7071

---

What is the meaning of decode in informatica?

1071

---

Define enterprise data warehousing?

1128

---

What's the layout of parameter file (what does a parameter file contain?)?

2331

---

Where can we find the throughput option in informatica?

995

---

What is workflow monitor?

994

---

Is it possible to create multiple domains on a single Informatica server?

1176

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10629

---

What is blocking transformation?

1079

---

Do you find any difficulty while working with flat files as source and target?

1050

---

What does update strategy mean, and what are the different option of it?

1034

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1106

---

Parameter and variable differences

2002

---