Answer / niranjana

Datawarehouse objects are Dimension tables,Fact tables,Unique identifiers and relationships

Answer / manju

Sources, Targets, Mappings, Mapplets, sessions, workflows,
worklets, tables, views, sequences,procedures, cursors... are
objects part of data warehouse.

What is galaxy shema

2 Answers   CGI,

---

what is Active lock explain

0 Answers   Satyam,

---

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

difference between shortcut and reusable transformation?

2 Answers  

---

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

---

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,

---

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

---

why we use source qualifier transformation?

16 Answers   Accenture,

---

In a sequential batch can you run the session if previous session fails?

4 Answers  

---

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

---

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

---