Answer Posted / mahaboob basha
select users.user_id, users.email, max(classified_ads.posted)
from users, classified_ads
where users.user_id = classified_ads.user_id
group by users.user_id, users.email
order by upper(users.email);
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Scheduling properties,whats the default (sequential)
How can a transformation be made reusable?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How would you copy the content of one repository to another repository?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is an unconnected transformation?
What is an active transformation?
What are the prerequisite tasks to achieve the session partition?
what is the size of your data warehousing?
I have a flat file, want to reverse the contents of the flat file
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Quickly characterize reusable change?
What is the commit type if you have a transaction control transformation in the mapping?
How do you set a varible in incremental aggregation