Answer Posted / kiran

1)totally how many jobs created in ur project?
Ans:Depend upon duration: suppose u mentioned as like 12-15
months:52 jobs
2)what is ur datamart size & Dwh size
Ans: no one know about size of the DWH but u can define as
like it should be tera bites and datamart size is 6 gb
3)How secure ur project
Ans:take care under Admin
4)could u plz tell be about testing process after complete
the job will run sucessfully or not in Datastage

How will you move hashed file from one location to another location?

2213

---

Explain usage analysis in datastage?

1222

---

What are the difference types of stages?

1285

---

What is the difference between informatica and datastage?

1299

---

Can you explain players in datastage?

1245

---

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

1578

---

what is flow of project?

2051

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3693

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2265

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1206

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1267

---

How one source columns or rows to be loaded in to two different tables?

1174

---

How to implement complex jobs in data stage?

1156

---

Where do you see different stages in the designer?

1140

---

Triggers,VIEW,Procedures

1262

---