Question { Cognizant, 7422 }

In SCD type 2 if we had select date range.
then suppose we had inserted today's date(eq. date is 30 aug
2010) then start date will be today's date(30 aug 2010)
what will be the end date,we cant leave it blank?

Answer

when ll we insert the data into target the systam date
insert into start date and in end date null
tomarrow we insert 50 rec into target table in that 25
update 25 new.
update rec inserting as a new rec(target table contain 50
rec and update as insert means 25 rec inserting from 51)

Question { IBM, 4658 }

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

Answer

Lookup is better as compare to join
bcoz joiner does not supports to inequality but look
supports to inequality
and both r does not support OR condition

Question { TCS, 6640 }

explain different levels in pushdown optimization with example?

Answer

1. Source side push down
Integration service determine the T/r logic it ll send
as much as possible to source data base server

2.Target side push down
Integration service determine the T/r logic it ll send
as much as possible to targer data base server

3.fullside push down
Integration service determine the T/r logic it ll send
to source and target data base server

Question { Hexaware, 6975 }

how to through logic of informatica using the push down
optimization into oracle.

Answer

Asession configure for push down optimization to Increase
the session performance.
The I.S Analyze the mapping and T/r logic and determine T/r
logic it ll send to the source or Tager data base
I.S is convert the T/r logic into SQL then send to the data
base server
there r 3 types
1. Source side push down
2.Target side push down
3.fullside push down

Question { HP, 4900 }

without dynamic lookup how to insert new rows and update
existing rows?

Answer

using Update strategy

Question { Cap Gemini, 8655 }

i having mapping
emp---> sq_emp--->target
using this mapping i have to load dept table values into
target... (condition assume there is no primary and foreign
key relation between emp(table x) and dept (table Y))

Answer

question is incorrect
how to load in target two table with out PK and FK