Answer / srinu

The Dimension table which is shared by more than one fact
table is called confirmed dimension
Eg: Time Dimension

The fact table which doesn't have any fact information is
called factless fact table

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

0 Answers  

---

Define Data Stage?

0 Answers  

---

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

0 Answers  

---

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

---

What is the difference between orabulk and bcp stages?

0 Answers  

---

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,

---

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

---

how many dimentions and fact tables used in your project and what are names of it?

3 Answers   Tech Mahindra,

---

What are the unit test cases you used in your project?

1 Answers   CSC, HY,

---

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

---

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  

---