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
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How many ways a relational source definition can be updated and what are they?
How do you load alternate records into different tables through mapping flow?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain in detail scd type 2 through mapping.
Briefly define reusable transformation?
What is aggregate cache in aggregator transformation?
What is meant by target load plan?
Explain the types of transformations?
How to generate sequence numbers using expression transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain scd type 3 through mapping.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process