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 sql override?what is the use of it?

4 Answers   Sonata,

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---

Difference between task flow and linear task flow

0 Answers  

---

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

---

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

Can you generate reports in Informatcia?

1 Answers  

---

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---

can we override a native sql query within informatica? How do we do it?

0 Answers  

---

What is critical mapping?

2 Answers  

---

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---

In dimension and fact table? which one holds big data?

2 Answers  

---