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
What is parallel processing in informatica?
What is workflow manager?
Design a mapping to load a target table with the following values from the above source?
How to load last n records of file into target table - informatica
What is the commit type if you have a transaction control transformation in the mapping?
What the difference is between a database, a data warehouse and a data mart?
How do you take back up of repository?
What is exclusive and normal mode for repository services?
What are the differences between a connected lookup and unconnected lookup?
How many numbers of sessions can one group in batches?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is meant by a domain?
design of staging area?
How will the document be delivered to me?
Where do we use mapping variables in informatica?