Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---

Define maping and sessions?

3 Answers  

---

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  

---

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

---

How to load last n records of file into target table - informatica

0 Answers   Informatica,

---

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

---

What are active transformations? Name them.

1 Answers  

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

---

How to create Target definition for flat files?

0 Answers   Informatica,

---