Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4587 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 does refresh system mean, and what are its distinctive choice?
explain about unit testing? in real time?
What is a snowflake schema?
How to create a non-reusable instance of reusable transformations?
Explain in detail about scd type 1 through mapping.
What do you understand by term role-playing dimension?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are data-driven sessions?
What is enterprise data warehousing?
Informatica Checkpoints
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the use of transformation?
What if the source is a flat-file?
What is parallel processing in informatica?
