Answer / abhinaw prakash

When we issue Select * from View it'll fetch the data from
the Base table were as with Materialized view when we issue
select * from Materialized view it ll fetch the data from
the materialized view.

Also with using materialized view we can escape the run time
joins that it ll have to do when retrieving for a query.

Also with View you cannot schedule it for refresh but with
MV we can schedule it for Refresh

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

---

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,

---

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

---

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

---

How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,

---

Can a joiner be used in a mapplet.

1 Answers  

---

What is Target Update Override? What is the Use ?

8 Answers   Patni,

---

What are variable ports and list two situations when they can be used?

1 Answers  

---

How we can use union transformation?

0 Answers  

---

Two Default User groups created in the repository are ____ and ______

2 Answers  

---

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,

---

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

---