Answer Posted / chakravarthy kanishka

Look doesnt requires common key coloumn, then why we need key,
if we go for sequential file as a look up, and squential file have huge data,then it hits the performance,again you need to apply the performance techniques to the sequential file while reading the data,so better to avoid sequential file as a reference to look up.

its my guess...
please let me know if wrong.

thanks
kanishka

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2185

---

How to read the length of word in unix?

1377

---

What are the stages in datastage?

1081

---

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

2252

---

How do you start developing a datastage project?

1103

---

Define meta stage?

1200

---

What is the difference between an operational datastage and a data warehouse?

1153

---

Where the datastage stored his repository?

1087

---

What is meta stage?

1178

---

What is the project in datastage?

1111

---

What are datastage sequences?

1118

---

Can you define merge?

1118

---

what is the use of materialized view?

1567

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1274

---