Answer Posted / krishna

Generally we are using lookup for comparision purpose,
based on the reference table size we r using join or lookup.

If the reference table size is less than the main table
then use lookup stage other wise use join stage.
In lookup we have two types:
Normal lookup - reference lookup is less no of rows
compared to main table
sparse lookup - reference lookup is more no of rows
compared to main table.
But the peformance wise use join if the reference table has
more data.

Regards,
Krishna

What is the difference between server job and parallel jobs?

1202

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

981

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1210

---

which r the connectors used in san?

2231

---

Name the third party tools that can be used in datastage?

1140

---

How to implement complex jobs in data stage?

1162

---

AGGREGATOR default datatype

1526

---

What is the importance of the exception activity in datastage?

1115

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2260

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2323

---

Differentiate between Join, Merge and Lookup stage?

1142

---

Difference between data warehousing and olap?

1151

---

What are stage variables?

1257

---

what is the use of materialized view?

1639

---

Explain entity, attribute and relationship in datastage?

1157

---