Answer Posted / nandini

Normal lookup:- U r having 90% data in primary like(source
table) and 10% data of Refference link(lookup table)in kind
of sutivation we can use normal lookup.and the normal
lookup data can stores in the temprovary memory.

Sparse lookup:-U r having 10% data in primary like(source
table) and 90% data of Refference link(lookup table)in kind
of sutivation we can use sparse lookup.and the sparse
lookup data can not stores in the temprovary memory because
it s having the huge data.

How to implement complex jobs in data stage?

1074

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

975

---

Can you define merge?

1077

---

What is the command line function to import and export the ds jobs?

1111

---

What are the different options associated with dsjob command?

1398

---

How can one find bugs in job sequence?

1345

---

Name the different types of Lookups in Datastage?

1226

---

What all the types of jobs you developed?

1139

---

Difference between data warehousing and olap?

1064

---

What are stage variables?

1159

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1975

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1193

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2210

---

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

745

---

Explain connectivity between datastage with datasources?

951

---