Answer Posted / pranalika

Above certification codes: 000-418 and 000-421 was expired and IBM released new certification codes as below:

C2090-421 : InfoSphere DataStage v8.5
C2090-303 : IBM InfoSphere DataStage v9.1

I got latest dumps from this link : http://bit.ly/Sy4o9I

Can we use target hash file as a lookup ?

3264

---

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)

2661

---

What is orabulk stage?

992

---

What are the steps required to kill the job in Datastage?

1150

---

What are sequencers?

1059

---

What is job control?

1035

---

What are system variables and sequencers in datastage

1072

---

what is the use of materialized view?

1489

---

How to implement complex jobs in data stage?

1053

---

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.

2839

---

How many types of sorting methods are available in datastage?

1020

---

What is the difference between passive stage and active stage?

1413

---

State the difference between an operational datastage and a data warehouse?

1058

---

Give an idea of system variables.

963

---

Can you explain engine tier in information server?

1063

---