Answer Posted / manjula

it is not possible to actually join two tables without
using any condition.
if U would like to join two tables, then in source
qualifier transformation add all the port from two tables (
if both tables are from same database source) and write
down your join condition in user defined join option or
otherwise write down join condition inside the sql query
option with generated sql query.

if u use two different database source then use joiner to
join the two tables

write a query to retrieve the latest records from the table sorted by version(scd)

1049

---

How to extract sap data using informatica?

1026

---

What is the function of union transformation?

1109

---

what is degenerated dimension?

3962

---

What are the components of workflow manager?

1074

---

What if the source is a flat-file?

1089

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1261

---

What are multi-group transformations?

1068

---

Global and Local shortcuts. Advantages.

2016

---

What are the new features of Power Center 5.0?

1752

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1261

---

How can we handle two sessions in informatica?

1018

---

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

1170

---

What is domain and gateway node?

1152

---

What are the settings that you use to configure the joiner transformation?

1038

---