Answer / bhargavi

Facts are numeric values (or) daily transactions done to any
business.

Dimensions are detail information about business

E.g.,: cust no,customer name,addr...

Answer / mohammadsadiq

Facts in Banking

Account no


Dimensions in Banking

Branch
Amount

Answer / subhash

FACT Table:(Daily transaction details)
Transaction_Details

Dimension Tables:(Which have static data)

Customer_details
Account_Details

DATE & TIME

Answer / saikumar

Fact Table: it contains all the transnational Data of the customer 
eg: deposited date,withdrawn date etc...


Dimensional Table: it contains non-transnational Data of the customer

eg:  c.city,c.loc,c.cname etc.

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,

---

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,

---

What is the difference between datastage and informatica?

0 Answers  

---

why do u need the IOS upgradation in a FC switch

0 Answers   IBM,

---

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 Answers  

---

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

5 Answers   FIS,

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

how to create document in datastage?

1 Answers   Cap Gemini,

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

---

How rejected rows are managed in datastage?

0 Answers  

---