Question { 4171 }

Comment on significance of oracle 9i in informatica when
compared to oracle 8 or 8i?

Answer

In case of Informatica,Oracle 8 or 8i not supported Bulk
loading where oracle 9i supported that.

Regards

Sukanta

Question { Wipro, 7157 }

In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?

Answer

The interviewer just check your knowledge about Informatica
Lookup Transformation.

If you disable cache you can't override the default sql query.

Follow Informatica Help.

Regards
Sukanta

Question { HCL, 7988 }

What is an incremental loading? in which situations we will
use incremental loading

Answer

Incremental Loading is an approach.Let suppose you a mapping
for load the data from employee table to a employee_target
table on the hire date basis.Again let suppose you already
move the employee data from source to target up to the
employees hire date 31-12-2009.Your organization now want to
load data on employee_target today.Your target already have
the data of that employees having hire date up to
31-12-2009.so you now pickup the source data which are
hiring from 1-1-2010 to till date.That's why you needn't
take the data before than that date,if you do that wrongly
it is overhead for loading data again in target which is
already exists.So in source qualifier you filter the records
as per hire date and you can also parametrized the hire date
that help from which date you want to load data upon target.

This is the concept of Incremental loading.

Question { 15378 }

Can we update the data in flat file using update strategy?

Answer

No.

Regards

Sukanta

Question { HP, 7660 }

hi talents,
how do u get sequece numbers with oracle sequence generator
function in informatica.... i dont need to use sequence
generator transformation..... how do u achieve this???

Answer

You can call the DB sequence generator in the source
qualifier override sql query.Generate sql query first,add
the SG name in the sql query and alias as a port exist in
database table.

You will get the solution.I check it.

Regards
Sukanta

Question { CTS, 13017 }

Hi Experts,

Performance Wise Which transformation is better in LOOKUP
AND JOINER TRansformations? Why? Can anybody please explain
it ?
Please help me out from this Question.

Thanks In Advance.

Answer

Look up will better perform because the cache is initially
created when the first record will reach at Look up
tarnsformation and the further records are work upon the
cached records.Look up will perfrom left outer Join
only.Other Joins can't be posible.You can check the records
are either exists in the lookup table or not.

Jioner will be slower than look up but sorted port
Join,well choosing of Master and detail configuration will
give better performance for Joiner.