Answer Posted / tauseef

if the two sources or coming from same datasource then we
can use source Qualifier trans to join
if it is coming from different then same add a dummy port on both the tables and join

if its wrong send me the soulution to my id tauseefwst@yahoo.com

Can we override a native sql query within informatica?

987

---

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

1009

---

What are the different transaction levels available in transaction control transformation?

1119

---

What are the advantages of informatica?

956

---

In informatics server which files are created during the session rums?

1063

---

Define update strategy?

1111

---

Explain the types of transformations?

1005

---

Slowly changing dimensions, types and where will you use them

1654

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1506

---

In how many ways we can create ports?

1067

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1864

---

What is the need of etl tools?

1051

---

Explain the difference between mapping parameter and mapping variable?

979

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2057

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1039

---