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
- 19311 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
Can we change Dynamic to Static or Persistent cache? If so what happens?
Define update strategy?
How to join three sources using joiner? Explain though mapping flow.
Is there any target staging area in informatica not staging area
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are Dimensional table?
Write the unconnected lookup syntax and how to return more than one column.
what is unit testing?tell me proceedure
have u done any performance tuning? how u ll do?
What are the differences between source qualifier and joiner transformation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Where are the source flat files kept before running the session?
Explain lookup transformation in informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a connected transformation?
