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

Answers were Sorted based on User's Feedback



i have one senario i have table with 2columns one for primary key another is a constant value(ze..

Answer / srikanthlavu

sorry

Is This Answer Correct ?    0 Yes 0 No

i have one senario i have table with 2columns one for primary key another is a constant value(ze..

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

Post New Answer

More Informatica Interview Questions

list out all the transformations which use cache?

0 Answers   Informatica,


explain abt union t/r?

1 Answers   IBM,


what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,


Which is the t/r that builts only single cache memory?

0 Answers  


comonly how meny mappings r there in Banking projects?

1 Answers  






Can we create two repositories on same database instance in oracle?

0 Answers  


how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  


I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,


write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,


i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...

4 Answers   Keane India Ltd,


Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,


Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  


Categories