Answer Posted / subhash

what Ankit explained is correct. but small correction:
as per abouve explanation we get o/p location as below:
LOCATION
,chennai,hydrabad,pune,banglore
,chennai,mumbai,bangloore
,hydrabad,chennai
,pune

So, we need to do LTRIM/TRIM Function in devivation of the
column:
TRIM(temp1,',')---------->Location

then we get desired output.

Can you explain players in datastage?

1178

---

What are constraints and derivations?

1151

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2027

---

Why fact table is in normal form?

1217

---

How do you generate sequence number in datastage?

1072

---

sed,awk,head

1447

---

Differentiate between odbc and drs stage?

1035

---

What are the functionalities of link partitioner?

1004

---

Explain the importance of surrogate key in data warehousing?

1172

---

How can we improve the performance in datastage?

1093

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4022

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3739

---

What is quality stage?

975

---

How complex jobs are implemented in datstage to improve performance?

1021

---

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

995

---