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
explain abt ur project architecture?
What is the difference between stop and abort in informatica
I have a flat file, want to reverse the contents of the flat file
How to start a workflow using pmcmd command?
On which transformations you created partitions in your project?
What is a code page?
How do you load only null records into target? Explain through mapping flow.
What are the guidelines to be followed while using union transformation?
What are the informatica performance improvement tips
What is the surrogate key?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
how to load dimension table and fact table. plz tell me the steps.
How to elaborate tracing level?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the way to execute pl/sql script using informatica mapping?