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)

Does an informatica transformation support only aggregate expressions?

0 Answers  

---

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

---

When do you use sql override in a lookup transformation?

0 Answers  

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

---

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

---

what is target load plan

2 Answers   Cap Gemini,

---

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

---

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

0 Answers   Zensar,

---

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

---

What is router transformation

4 Answers   CSC,

---

How we can confirm all mappings in the repository simultaneously?

1 Answers  

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,

---