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 / 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
How can a transformation be made reusable?
can you please explain me pre session and post session options?
What is sorter transformation?
How might one distinguish in the case of mapping is right or not without associating session?
Can u generate reports in Informatica?
Explain what transformation and how many are there in informatica?
How to generate sequence numbers without using the sequence generator transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
Explain the tuning lookup transformation - informatica
what is informatica metadata?
What is the surrogate key?
What is the status code in stored procedure transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is a grid in Informatica?
To import the flat file definition into the designer where should the flat file be placed?