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
- 19573 Views
- Deloitte, I also Faced
- E-Mail Answers
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 sessions in informatica etl?
Define enterprise data warehousing?
What are different types of transformations available in informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How do you change a non-reusable transformation to reusable transformation?
How to extract sap data using informatica? What is abap? What are idocs?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Performance tuning( what you did in performance tuning)
How do you migrate data from one environment to another?
what is Active lock explain
What are the reusable transformations?
Where do we use mapping variables in informatica?
Define joiner transformation?
How do you take back up of repository?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
