Answer Posted / prasanna

Using lookup is equivalent to outer join on source table.
As Bhavani said, if you want to join 2 heterogeneous
sources you cannot join in SQ. Then you need to use join.

Ex: you have 2 sources. One is a table in a DB and another
is a faltfile then you can only join using joiner.

Adv: you can perform operations similar to inner, left
outer, right outer and full outer. But using a lookup its
equivalent to left outer join on source.

It's always better to join a table which is small in SQ
then creating a lookup on it for better performance

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2236

---

what are Lookup caches options? Including persistent caches.

1976

---

how would u estimate the size of Lookup transform data and index cache?

2134

---

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1806

---

how does the server recongnise the source and target databases.Elaborate on this

2693

---

When do we go for the tools in the market?

947

---

What are the modules in Power Mart?

961

---

SCD2 will work on only dimension tables as well as fact Table?

1401

---

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2056

---

What are three tier systems in etl?

1066

---

What is a mapping, session, worklet, workflow, mapplet?

992

---

What are dimensions?

1068

---

what is the difference between cardinality and Nullability?

2949

---

What is grain of fact?

983

---

What are the ETL Testing Operations?

1052

---