How informatica process data means how informatica works?

TCS,

Can we run session without using workflows?

TCS,

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

TCS,

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

TCS,

Which is better performance wise database or file?How?

TCS,

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

how to join two flat files in informatica?

Wipro,

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

Wipro,

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

Wipro,

in what type of scenario bulk loading and normal loading we use?

Cognizant, Wipro,

how can we run workflow with pmcmd?

Wipro,

why we use informatica in our project?

TCS,