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
- 5813 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are multi-group transformations?
What are the measure objects?
What are the prerequisite tasks to achieve the session partition?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is target designer and target load order?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
tell me 5 session failure in real time how can you solve that in your project?
What is rank transformation in informatica
Is it possible to define a single node as a Gateway node as well as worker node?
What is transformation?
What is the difference between a connected look up and unconnected lookup?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is source qualifier transformation in informatica?
What is meant by LDAP users?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
