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

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2245

---

How to call shell scripts from informatica?

1043

---

Explain transaction control transformation in informatica

1312

---

How many ways are there to create ports?

1403

---

What are the issues you have faced in your project? How did you overcome those issues?

2412

---

How many ways a relational source definition can be updated and what are they?

1064

---

What is aggregator transformation in informatica?

1004

---

is it possible to index the data in cache of lkp transformation ?

2076

---

what is diff b/t sorter t/r and agg have the option sorter property...

2231

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4779

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2290

---

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

2437

---

How many types of sessions are there in informatica.please explain them?

1210

---

How to do the error handling of if ur source is flatfiles?

2017

---

What is a filter transformation and why it is an active one?

1015

---