Answer Posted / surajit n bhowmick

A View is just a stored query and has no physical role.
Once a view is instantiated, performance can be quite good,
until it is aged out of the cache.

A materialized view has a physical table associated with
it, it does not have to resolve the query each time it is
queried. Depending on how large the result and how complex
the query, a materialized view should perform better.

Explain in detail scd type 2 through mapping.

991

---

Explain the informatica workflow?

1005

---

what is mean by complex business rule ?

2110

---

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

4071

---

Which transformation should we use to normalise the COBOL and relational sources?

1143

---

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.

2296

---

What is the cumulative sum and moving sum?

1139

---

What the difference is between a database, a data warehouse and a data mart?

1082

---

How many ways are there to do 'remove duplicate records in informatica'?

956

---

Describe expression transformation?

1045

---

Explain how many types of dimensions are available in informatica?

1010

---

What is an expression transformation in informatica?

964

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1896

---

What is informatica?

1080

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2209

---