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
- 19567 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / kalyan
I guess the below logic will solve this question..
Sq -> Expression T/R -> Aggr t/r -> Target
Create a constant port in Expression t/r and then pass the 3
fields id, date & const port to the aggregate t/r... Create
a new port calculating mindate.. Now do a group by on the
Const field ; connect id & min Date fields to the Target...
FYI, If u don't apply group by on any column of the table ;
can not calculate the Aggr values...
Please correct me if I am wrong...
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
4 yrs etl devloper roles and responsibilities?any body give solutions
What is target load order?
What is domain in terms of informatica?
Define update strategy?
Briefly explain the aggregator transformation?
Differences between version 7.x and 8.x.
What are the different types of transformation available in informatica.
Which transformation is needed while using the Cobol sources as source definitions?
How can we use batches?
What is an expression transformation?
What happens when a session fails and you click on recover?
Explain how many types of dimensions are available in informatica?
What is lookup change?
What is informatica worklet?
difference between informatica 8.1.1 and 8.6
