Answer / bidhar

First thing to note is that Both the sources must be
Homogeneous.
Also the Order of the ports in SQ and the order of the
Columns in the select query (if you are using SQL override)
must be same.

Answer / krishna

1.two or more relational tables are with primary key-
foreign key relationships by linking the sources to one
Source Qualifier transformation.
2.the data types of the ports must match.

violation of these two conditions may lead to errors while
joining two tables

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

what is $$$$?

0 Answers   TCS,

---

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

---

How many ways you create ports?

1 Answers  

---

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  

---

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

star and snowflake schema?

6 Answers  

---

Which kind of index is preferred in DWH?

2 Answers  

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---