Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 5627 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chiky
for getting max vales, go for aggregate.. and not for
lookup.
after taking max values using aggregate, using dummy
columns join agg value and your source table value..
after that you can have your lookup what ever needed.
| Is This Answer Correct ? | 0 Yes | 0 No |
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
Explain the different dimensions.
How do you use reject loader.
connected and unconnected lookups?
how to remove staging area
What is an aggregator transformation?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
How to improve the performance of Aggregate transformation?
Can you generate sequence numbers without using the sequence generator transformation?
What is the difference between a shortcut of an object and copy of an object? Compare them.
what transformations are used for Variable port?
Teradata 
