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
- 4327 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
Why update strategy and union transformations are active?
How to handle decimal places while importing a flatfile into informatica?
How to extract sap data using informatica?
Enterprise data warehouse your projects phase by phase explain?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
what is the -ve test case in your project.
Is it possible to revert a global repository to local one and why?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Briefly describe lookup transformation?
How can we create index after completion of load process?
What is the need for an etl tool?
What is meant by lookup transformation? Explain the types of lookup transformation?
What are the different components of powercenter?
What is fact table? Explain the different kinds of facts.
