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
- 5809 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 |
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
how to load dimension table and fact table. plz tell me the steps.
Mention some types of transformation?
How can you complete unrcoverable sessions?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
what is lookupoverriding?
Name 4 output files that informatica server creates during session running?
What are the new features of informatica 9.x in developer level?
Can we combine a flatfile and a database table using an UNION transformation?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
Teradata 
