Answer Posted / mcssrinivas009

select RANK , D *from(select roumun RANK,E. *from E) D where
RANKIN 1,2,5,6;
using this query we getting from our requirement

How to find value from a column in a dataset?

2253

---

Explain the importance of surrogate key in data warehousing?

1234

---

Notification Activity

1460

---

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

1308

---

Could anyone give brief explanation bout datastage admin

2408

---

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)

2781

---

What is the difference between orabulk and bcp stages?

1076

---

What are the differences between datastage and informatica?

1229

---

root tree will find which is server job and which is parallel job?

2040

---

What is the difference between hashfile and sequential file?

1320

---

Where do the datastage jobs get stored?

1270

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2115

---

What are the primary usages of datastage tool?

1131

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1583

---

What is the purpose of pivot stage and types of containers in datastage

1082

---