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.

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

---

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

---

What is lookup change?

0 Answers  

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

explain abt joiner t/r?

1 Answers   IBM,

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

---

what is the size of u r source(like file or table)?

0 Answers   HP,

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

Can i create a lookup table without cache.

7 Answers   iGate,

---

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

---

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

---