Question { 5030 }

how to identify new and old values in source qualifier or
any other transformations using informatica

Answer

old values you might store in target right?then use that
old values for comparision of new values by using lookup
tranformaton....give key port lkp t/n from sq and give
condition like oldvalue=newvalue
if condition true means those are old vakues

Question { TCS, 4707 }

i have one senario
i have table with 2columns one for primary key another is a
constant value(zero). i have to lookup the table and get the
maximum primary key here i don't have any common column
between source and lookup table(wt table i explained
above)...
table is (i am assuming he didn't give the table)
column1 column2
5 0
2 0
8 0
6 0
3 0
12 0
7 0

Answer

sorry

Question { 3803 }

hi all,
Can anyone please tell me the relationship between
informatica and business objects

Answer

By using infor matica we will design one to many relation
ship between fact and dimension tables..By using Business
object we will take those relational tables and will
prepare reports