Answer Posted / subbuchamala

Sparse LookUp:
for each source value, It will go refernce Database and get the Output.

Normal lookup:- 90% data in primary like(source
table) and 10% data of Refference link(lookup table)then we can use normal lookup.and the normal
lookup data uses in the temporary memory(RAM).

Sparse lookup:- 10% data in primary like(source
table) and 90% data of Refference link(lookup table)then we can use sparse lookup.

Can you explain players in datastage?

1246

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

855

---

How to reverse the string using unix?

3589

---

What is datastage engine?

1224

---

What are the different layers in the information server architecture?

1172

---

What are the partitioning techniques available in link partitioner?

2326

---

What are the steps required to kill the job in Datastage?

1265

---

What is the purpose of pivot stage?

1231

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2444

---

Describe the main features of datastage?

1123

---

What are stage variables?

1252

---

What are the features of datastage flow designer?

1099

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2138

---

What are the types of hashed files in data stage

1146

---

what are the errors,warnings in datastage

2764

---