Answer / ricky

Both the sources should come from homogenious / same
database.

Answer / swetha

Two sources should have primary and Foreign key relation ships.

Two sources should have matching data types.

Answer / bidhar

Sources should be Homogeneous.Though they might not have a
joining condition.
For Example If you have Employee table and Dept Table and
the joining condition is on deptid then its not mandatory
that you must specify the joining condition.If you dont
specify the joining condition then it will have a cartesian
join.

Also the Ports Serial should be same as the SQ override
select.

Answer / madhu

The Transformation which Converts the source(relational or
flat) datatype to Informatica datatype.
So it works as an intemediator between and source and
informatica server.

Tasks performed by qualifier transformation:-
1. Join data originating from the same source database.
2. Filter records when the Informatica Server reads source
data.
3. Specify an outer join rather than the default inner join.
4. Specify sorted ports.
5. Select only distinct values from the source.
6. Create a custom query to issue a special SELECT
statement for the Informatica Server to read source data.

What is a mapplet/worklet in informatica?

0 Answers  

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

What is the difference b/w natural key and surrogate key

1 Answers  

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

r u done any partitions in ur project?

0 Answers   TCS,

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

---

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

---

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,

---

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

---