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
- 5717 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
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How would you copy the content of one repository to another repository?
On which transformations you created partitions in your project?
What is meant by lookup transformation?
Differences between connected and unconnected lookup?
whats the logic to load the lower level of granularity of data to fact table.
What is the format of informatica objects in a repository?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is joiner transformation in informatica?
What is a router transformation?
How you prepared reports for OLAP?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
explain abt ur project architecture?
How can you define user defied event?
