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);

how many types of dimensions are available in informatica?

1087

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1049

---

Define pmcmd command?

1036

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2160

---

What is deployment group?

1201

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2028

---

What is informatica worklet?

1057

---

Write the program through which the records can be updated?

998

---

Is it possible to create multiple domains on a single Informatica server?

1234

---

What is informatica?

1144

---

What are the performance considerations when working with aggregator transformation?

1147

---

Explain joiner transformation in informatica

1121

---

I have a flat file, want to reverse the contents of the flat file

1119

---

Enlist the differences between database and data warehouse.

1115

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2242

---