Answer / giri

Sorter Aggregator
------- -----------
1.Asc and Desc Only Asc order purpose
order purpose
2.Query is not Passible query is passible

Answer / dkr

Sorter uses the sorter Algorithm, but Aggrigator uses a
physical Algorithm -(called CLUSTERED Algorithm)

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

---

What is informatica etl tool?

0 Answers  

---

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

---

Differentiate between a database and data warehouse?

0 Answers  

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

How can you display only hidden files in UNIX

4 Answers   Cognizant, L&T,

---

What is galaxy shema

2 Answers   CGI,

---