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

Parameter and variable differences

2006

---

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

1014

---

Sequence generator, when you move from develoment to production how will you reset

1943

---

What are the types of caches in lookup?

978

---

Write the advantages of partitioning a session?

1209

---

Explain constraint based loading in informatica

1041

---

What is a repository? And how to add it in an informatica client?

1084

---

How do you load only null records into target?

1144

---

What are the different lookup cache(s)?

1036

---

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?

2210

---

How can you increase the performance in joiner transformation?

1136

---

Performance tuning in UNIX for informatica mappings?

2508

---

Could you explain what is enterprise data warehouse?

1051

---

Explain the different dimensions.

917

---

What are the performance considerations when working with aggregator transformation?

1097

---