Answer Posted / sheelendra

I agree with Srinu.
and It will return only one aggregated value for all input.

Can u generate reports in Informatica?

1082

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1246

---

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

1017

---

How would you join a node to the already existing domain?

1127

---

What is the Process to creating lookup transformation in informatica

1042

---

What is the need of an ETL tool?

1085

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2064

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1626

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1263

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2192

---

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

1791

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2034

---

what is diff b/t sorter t/r and agg have the option sorter property...

2171

---

What is the use of code page?

1086

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4108

---