Answer Posted / ramesh

A Fact table is a table that contains the measures of
intersert.
A dimensional table is a collection of hierarchies and
categories along which the user can drill down and drill
up. it contains only the textual attributes.

What all are the different way to run a job?

1100

---

What is datastage?

1095

---

Which commands are used to import and export the datastage jobs?

1419

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2116

---

Name the command line functions to import and export the DS jobs?

1168

---

What are the partitioning techniques available in link partitioner?

2284

---

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.

2912

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2166

---

What is job control?

1126

---

What is the difference between hashfile and sequential file?

1271

---

What is data partitioning?

1218

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2188

---

What is the process of killing a job in datastage?

1026

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1047

---

Which warehouse using in your datawarehouse

2196

---