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 is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  

---

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

---

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

---

which quality process u can approach in ur project

1 Answers   CTS,

---

What is update override?

1 Answers   Accenture,

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

What are the out put files that the informatica server creates during the session running?

2 Answers  

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  

---