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
- 18989 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
what is the size of u r source(like file or table)?
How to load last n records of file into target table - informatica
Explain the scenario which compels informatica server to reject files?
What are the modules in Power Center
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Does an informatica transformation support only aggregate expressions?
have u done any performance tuning? how u ll do?
can u give example for factless fact table
write a query to retrieve the latest records from the table sorted by version(scd)
what is the size of your data warehousing?
What is a connected transformation?
Tell me about Propagate functions in informatica
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the tuning techniques you applied during your last project
