Answer Posted / pendekanti praveen kumar

Before using mapping parameters and mapping variables we
should declare these things in mapping tab of mapping
designer.

A mapping parameter cannot change untill the session has
completed unless a mapping variable can be changed in
between the session.

Example:::
if we declare mapping parameter we can use that parameter
untill completing the session,but if we declare mapping
variable we can change in between sessions.Use mapping
variable in Transcation Control Transformation......

What is the need of etl tools?

623

---

What is sq transformation?

679

---

Differentiate between joiner and lookup transformation?

626

---

Explain Dataware house architecture .how data flow from intial to end?

2135

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1744

---

---

Explain load alternative records / rows into multiple targets - informatica

709

---

Slowly changing dimensions, types and where will you use them

1288

---

Have you worked with/created Parameter file

1238

---

Explian the Process of deployment groups in informatica

669

---

What is target designer and target load order?

669

---

What you know about transaction control transformation?

570

---

Can we create two repositories on same database instance in oracle?

622

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1631

---

Explain the difference between a data warehouse and a data mart?

606

---

Explain lookup transformation is active in informatica

673

---