Answer / Amber Goel

Propagate functions in Informatica are used to pass data from one transformation to another without physically moving the data. They allow you to create a flow of data where one transformation can pass its output as input to another transformation. This helps in reducing the number of transformations and improving the performance of the map. Examples of Propagate functions include INITIAL, TRANSFORM, and LAST.

What are the differences between joiner transformation and source qualifier transformation?

1 Answers   Informatica,

---

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

Explain what are the different types of transformation available in informatica.

1 Answers  

---

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

---

What is facttable granularity?

2 Answers  

---

What is the difference between informatica 7.0 and 8.0?

1 Answers  

---

Can we get 1st record through Informatica(without sequence number).

1 Answers  

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1 Answers  

---

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

---