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.

What is active and passive stage?

880

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1631

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2321

---

What is the difference between datastage and informatica?

613

---

How many Key we can define in remove duplicate stage?

822

---

---

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

547

---

How to convert RGB Value to Hexadecimal values in datastage?

3458

---

How many types of sorting methods are available in datastage?

633

---

Define Job control?

679

---

How can you write parallel routines in datastage PX?

620

---

What are the types of containers?

691

---

How many types of hash files are there?

612

---

What are the different kinds of views available in a datastage director?

605

---

What are the difference types of stages?

622

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2013

---