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 Posted / srikanthlavu

sorry

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create a Integration service without a Repository service and vice versa?

719


Define sessions in informatica etl?

610


can we override a native sql query within informatica? How do we do it?

637


Is it possible to revert a global repository to local one and why?

607


How to generate or load values in to the target table based on a column value using informatica etl tool.

604






How many transformations can be used in mapplets.

1447


What is the meaning of decode in informatica?

642


What are the informatica performance improvement tips

605


What are the performance considerations when working with aggregator transformation?

669


How do you handle two sessions in Informatica

653


What are the new features of Power Center 5.0?

1224


What is deployment group?

676


What is mapping debugger?

565


What is a sequence generator transformation?

565


Briefly define reusable transformation?

616