Answer / pr

The default join is inner join. But we can override it by using the SQL overide query and can perform any joins

What is an active transformation?

0 Answers   Informatica,

---

When the informatica server marks that a batch is failed?

1 Answers  

---

Explain grouped cross tab?

1 Answers   Accenture,

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

Define informatica repository?

2 Answers   Wipro,

---

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

---

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---

Why use shortcuts(Instead of making copies).

1 Answers  

---

There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  

---

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

---