Answer / sukanta

Drag two tables to mapping designer.Now with two tables two
source qualifier has come to the workspace among which you
delete second source's source qualifier.Now drag all ports
from 2nd source to first source qualifier.Now the first
qualifier have contained all ports of two sources.

But before than that in source analyzer you make a PK-FK
relation between two sources.Now in the source qualifier you
make a join condition upon that two port for PK-FK.

You get the solution.

Regards
Sukanta

Answer / tilak kumar dhar

We can use a Source Qualifier Transformation for this.

Perform the steps to achieve it:

1. Drag all the tables in Mapping Designer.
2. Delete all the source qualifiers associated with all the
tables.
3. Create a SQ transformation.
4. Drag all the columns from all the tables into the SQ
transformation.

Answer / kish

hi,

by using sql override....

Answer / rampriya

Create a Oracle source with how much ever column you want
and write the join query in SQL query override. But the
column order and data type should be same as in the SQL query.

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---

What is the difference between a table and the materialized view?

2 Answers  

---

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,

---

---

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

---

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,

---

what is SDLC way of code development?

0 Answers  

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

---

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

---