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
Answer Posted / srinu
I think its Simple, with Agg Transformation,
First Group by ID,
Then go with min (date) in same Agg Transformation.
I think its Help you,,,,,,
Any ??? r Corrections,,,Let me know
srinu.srinuvas@gmail.com
Is This Answer Correct ? | 21 Yes | 11 No |
Post New Answer View All Answers
Define mapplet?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are some examples of informatica etl programs?
What is target load order?
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 pmcmd command usage in informatica
Does an informatica transformation support only aggregate expressions?
Please let me know how to make Data masking in informatica..
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How does a rank transform differ from aggregator transform functions max and min?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are active transformations.
Explain the features of connected and unconnected lookup.