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
- 5682 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
How to join three sources using joiner? Explain though mapping flow.
What is an unconnected transformation?
explain abt ur project architecture?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is a rank transform?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is incremental aggregation?
How to Create a folder using pmrep command?
What are the different clients of powercenter?
Explain the etl program with few examples.
Describe an informatica powercenter?
How do you load first and last records into target table?
Explain what is informatica metadata and where is it stored?
What is a filter transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
