Answer / raam chowdary

i extract data from different sources like oracle,sap r/3,db2,flat files,terradata,mainframes..........
nearly 8fact tables
and 18dimension tables

Answer / lokesh

only one fact table and Meany dimension tables
datamarts is subject oriented database

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  

---

Define Job control?

0 Answers  

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

how can u connect the client system directly at any time?

1 Answers   IBM,

---

Which algorithm you used for your hashfile?

0 Answers  

---

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---

how do you pass parameters in a script?

1 Answers   L&T,

---

tell me abt Datastage trigger?

1 Answers   HP, IBM,

---

What are routines in datastage? Enlist various types of routines.

0 Answers  

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers   IBM,

---

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

---

what is operator combinality in datastage?

1 Answers   TCS,

---