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
- 5588 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 one is better performance wise connected/un-connected lkp?why?
What are the types of maping in Getting Started Wizard?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
How would you copy the content of one repository to another repository?
How we can confirm all mappings in the repository simultaneously?
Have you worked with/created Parameter file
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
What are the Differences between connected and unconnected lookup?
Explain what is informatica metadata and where is it stored?
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
How many number of sessions that u can create in a batch?
what is plsql table?
Teradata 
