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
- 5589 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
Explain lookup transformation source types in informatica
What is a node in Informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are the modules in Power Center
What is target designer and target load order?
What are junk dimensions?
What is the commit type if you have a transaction control transformation in the mapping?
What is parallel processing in informatica?
Which is the t/r that builts only single cache memory?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
explain one complex mapping with logic? sales project?
Where do we use mapping variables in informatica?
What is an unconnected transformation?
how many types of dimensions are available in informatica?
In warehouses how many schemas are there?
