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

Difference between data warehousing and olap?

1093

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2186

---

What are constraints and derivations?

1170

---

Distinguish between informatica & datastage. Which one would you choose and why?

1010

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2903

---

Define Merge?

1320

---

What are the job parameters?

1221

---

what is ds administrator used for?

1173

---

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

1130

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2615

---

What are the types of containers and how to create them?

980

---

What are orabulk and bcp stages?

1125

---

What are stage variables and constants?

1148

---

How we can covert server job to a parallel job?

1148

---

What is a folder? Difference types of stages?

1178

---