what is the definitions for Datawarehose and Datamart?

4 Answers  

---

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

---

what is time dimension? and how to populate time demension

2 Answers   TCS,

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

What are the job parameters?

0 Answers  

---

What are system variables and sequencers in datastage

0 Answers  

---

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

0 Answers  

---

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

---

What are the different plug-ins stages used in your projects?

0 Answers  

---

where we use column generator stage in real time scenario?

5 Answers   TCS,

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

3 Answers   TCS,

---

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

---