Answer / pk

Architecture of the project means..
1.Your Source and Target System.Source systems: like mainframe,oracle,people soft,db2.
2. Landing tables: these are tables act like source. Used
For easy to access, for backup purpose, as reusable for
Other mappings.
3. Staging tables: from landing tables we extract the data
Into staging tables after all validations done on the data.
4.Loading strategy like which u applied type 1,2 or 3.
5. Dimension/facts: these are the tables those are used for analysis and make decisions by analyzing the data.
6. Aggregation tables: these tables have summarized data
Useful for managers who wants to view monthly wise sales,year wise sales etc.

who r the users in B.O.XIR2?

2 Answers   PCS,

---

What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.

3 Answers   Collabera,

---

4.what is repository? types

8 Answers   TCS,

---

What is a loop? How can we overcome?

5 Answers  

---

What is the server based ranking? and its usage?

2 Answers  

---

Can i merge two dataproviders if they do not have common column?

3 Answers  

---

What is object stores?

0 Answers  

---

Explain in detail about type 2(scd),

0 Answers  

---

what is fantrap?

2 Answers  

---

Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?

2 Answers   iFlex,

---

can we cretae views in universe level?

2 Answers  

---

How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?

2 Answers   Wipro,

---