Answer Posted / sriharsha vemuri

Same Result

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1671

---

What are stage variables, derivations and constants?

673

---

Differentiate between data file and descriptor file?

619

---

How many types of sorting methods are available in datastage?

636

---

Why fact table is in normal form?

678

---

---

Can you explain tagbatch restructure operator?

705

---

What are the main features of datastage?

663

---

What is meta stage?

581

---

what is flow of project?

1559

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1808

---

Highlight the main features of datastage?

615

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

550

---

What is the difference between account and directory options ?

624

---

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

1663

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3316

---