Answer / rameshreddy

After dimension load takes place we can load the Fact tables.
and

size of data warehouse for small projects 100-500gb
medium projects 500-1000gb
large projects 1000-N gb

To import the flat file definition into the designer where should the flat file be placed?

1 Answers   Informatica,

---

What is a passive transformation?

1 Answers   Informatica,

---

What are Dimensional table?

1 Answers   Informatica,

---

Can you copy the session to a different folder or repository?

2 Answers  

---

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1 Answers   Informatica,

---

what is metadata?

6 Answers  

---

How do you recover rows from a failed session

1 Answers  

---

Which kind of index is preferred in DWH?

2 Answers  

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

2 Answers   IBM,

---

Mapplets can you use an active transformation in a mapplet,

1 Answers  

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1 Answers  

---