Answer Posted / deepthi

1.Use sorted data and enable option 'sorted i/p'
2.By using incremental aggregation
3.group by simple columns like numeric columns
4.use filter transformation before aggregator to avoid
unnecessary aggregation on unwanted columns.

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2139

---

Explain pmcmd command usage in informatica

1065

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2075

---

What are the measure objects?

1118

---

What is meant by LDAP users?

1112

---

draw informatica architecture 8.6 ?

3820

---

Describe an informatica powercenter?

1035

---

What is exclusive and normal mode for repository services?

1062

---

Explain the tuning lookup transformation - informatica

950

---

Define pmcmd command?

993

---

What is dimensional table? Explain the different dimensions.

1109

---

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 ?

1604

---

What is the difference between a connected look up and unconnected lookup?

910

---

Can you generate sequence numbers without using the sequence generator transformation?

1049

---

Why do we need informatica?

925

---