Answer Posted / rob

Add the below query to source qualifier's SQL OVERRIDE
and you will get the required output

select * from (select min(to_date(date,'dd/mm/yyyy'))as
d,id from emp
group by id order by d)where rownum =1;

source-->SQualifier(with query)----> target

in reporting we add some new objects,how we get the count of the newly added objects to the report

2194

---

What is confirmed fact in dataware housing?

6969

---

What are the informatica performance improvement tips

1093

---

Performance tuning in UNIX for informatica mappings?

2568

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2184

---

permutations of mapplet

2511

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1059

---

What is a dimensional model?

982

---

What are active and passive transformations?

1086

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1796

---

What are the data movement modes in informatica?

1159

---

can we override a native sql query within informatica? How do we do it?

1126

---

How can we use mapping variables in informatica?

1063

---

explain about unit testing? in real time?

2205

---

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.

1710

---