Interested to Buy Any Domain ? << Click Here >> for more details...
How to create a mapping ?
id date
101 2/4/2008
101 4/4/2008
102 6/4/2008
102 4/4/2008
103 4/4/2008
104 8/4/2008
O/P - shud have only one id with the min(date)
How to create a mapping for this
- 9 Answers
- 19317 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / bidhar
I think you can get this by SQ Override query itself.
SQ->Exp->Target
SQ Override Query:
SELECT ID,MIN(DATE) FROM TABLENAME GROUP BY ID.
Let me know if i am wrong.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
State the differences between sql override and lookup override?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
update strategy transformation in informatica
What is informatica metadata and where is it stored?
permutations of mapplet
Explain what are the different types of transformation available in informatica.
server hot-ws270 is connect to Repository B. What does it mean?
Whats there in global repository
What if the source is a flat-file?
What is Data Caches size?
Why do you use Mapping Parameter and mapping variable?
Explain in detail about scd type 1 through mapping.
difference between informatica 8.1.1 and 8.6
difference between repository database and repository service?
Explain the informatica workflow?
