Answer Posted / venki

lookup having one input link and n intermediate links one
reference link and one optional reject link
input data in sorted order
fore types of look are there
1.normal lookup
2.sparce lookup
these two more added in 8.1
3.range lookup
4.caseless sensitive
normal lookup
while doing normal lookup frist the reference data is
loaded in to memory this is used when the reference data in
high
sparce lookup
while doing the sparce lookup first for each input record
generate a sql quarry and made the operation in datadase
only one reference link the reference link should be
database or lookup file set only no intermediate links
this is used when the reference data is in low

Define orabulk and bcp stages?

1122

---

How many types of stage?

1177

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2865

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2061

---

What are the difference types of stages?

1214

---

What is size of a transaction and an array means in a datastage?

1311

---

Explain usage analysis in datastage?

1162

---

What are the different plug-ins stages used in your projects?

1078

---

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

2277

---

Define Merge?

1317

---

How a routine is called in datastage job?

1103

---

What are the types of containers?

1235

---

How many types of views are there in a datastage director?

1282

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2446

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

---