I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG
I need to get max date and its corresponding flag for both the date columns.
Ex:-
1A,10/3/2015,AC,10/3/2015,XY
1A,10/4/2015,AB,10/2/2015,XZ
Output needed
1A,10/4/2015,10/3/2015,XY
I have 100 million + in the table so avoid self-join...
- 2 Answers
- 3438 Views
- Amex, I also Faced
- E-Mail Answers
Answer Posted / kiran
Use aggregator transformation and check group by for ID Column and use max function for both the dates.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a node in Informatica?
Define enterprise data warehousing?
How to generate sequence numbers without using the sequence generator transformation?
Explain pmcmd command usage in informatica
Explain the mapping variable usage example in informatica
What are Dimensional table?
What the difference is between a database, a data warehouse and a data mart?
tell me about your project functionality
where to store informatica rejected data?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is a transaction control transformation?
What are multi-group transformations?
Explain the aggregator transformation?
How to implement security measures using repository manager?
How can we use batches?
