Answer Posted / venugopal [patni]

The 3 stages differ mainly in the memory they use,
treatment of rows with unmatched & their requirements for
data being input.
In detailed:
Lookup is used for less amount of data becausu it will
takes the data from source and store in buffer so every
time it process from buffer.
Join is used for huge amount of data because it directly
takes the data from disk so it process faster than lookup.
Joiner is used to join with different join conditions.
Merge is also used for huge amount of data. Merge has the
same number of reject links as there are updated updated
input links.

Explain datastage architecture?

1449

---

Terminate Activity

1335

---

What is the importance of the exception activity in datastage?

1111

---

How do you generate sequence number in datastage?

1139

---

Describe the architecture of datastage?

1060

---

What is the use of datastage designer?

1218

---

Can you explain repository tables in datastage?

1452

---

What is the difference between in process and inter process?

1198

---

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

2112

---

Can you explain kafka connector?

1377

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1128

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4237

---

Explain how a source file is populated?

1416

---

What are the components of ascential data stage?

1240

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

819

---