Answer / veera reddy

Basically there are two types of architectures.
1. Top Down(Dependent) and 2. Bottom up(Independent)

In Top Down approach initially DW comes and then DM.
In Bottom Up approach intially DM comes and then DW.

Answer / praveen kumar

step-01------>source to staging
step-02------>staging to dimension
step-03------>dimension to fact

This is the general procedure.........

Answer / rekha

PROJECT PLANNING
REQUIREMENTS GATHERING ---PRODUCT SELECTION AND INSTALLTION

DIMESIONAL MODELING --- PHYSICAL
MODELING ---- DEPLOYMENT --- MAINTENANCE

IN EASY TREMS FOR DIMENSIONAL MODELING
1. SELECT THE BUSINEE PROCESS
2 IDENTIFY THE GRANINS
3 . DESIGN THE DIMENSION TABLE
4 . DESIGN THE FACT TABLE
ONCE THESE 4 STPE ARE OVER IT WILL MOVE TO PHYSICAL
MODELING
IN PHYSICAL MODELING U APPLY THE ETL PROCESS AND
PERFORMANCE TECHNOQUES .

Answer / bsgsr

i simply put this way.
source to staging
staging to dwh

Answer / kumarapillaietl@gmail.com

first we integrate data into source to staging tables, from staging we movie into work table at the data moment of stage to work we do all transformation logic , then from work table we load data into fact and dimention table using scd 2.

Global and Local shortcuts. Advantages.

0 Answers  

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---

i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 Answers  

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 Answers   CTS, TCS,

---

---

Without source how to insert record to target?

6 Answers  

---

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---

performance wise which one is better in joiner and lookup transformation

2 Answers  

---

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

---

When to use normalization transformation other than cobol source?

2 Answers  

---

what is bridge tables in informatica

1 Answers   CTS,

---

Name 4 output files that informatica server creates during session running?

1 Answers  

---