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.

Why fact table is in normal form?

673

---

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

1801

---

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

1649

---

What is the precedence of stage variables,derivations, and constraints?

594

---

If you want to use a same piece of code in different jobs, how will you achieve this?

790

---

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1118

---

What is the process of killing a job in datastage?

589

---

What are routines in datastage? Enlist various types of routines.

627

---

How you can fix the truncated data error in datastage?

1191

---

How to clean the datastage repository?

691

---

in oracle target stage when we use load option and when we use upsert option?

1748

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1743

---

I have a few records just I want to store data in to targets cycling way how?

1896

---

how to delete one row in target dataset

2586

---

What are the steps needed to create a simple basic datastage job?

656

---