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
- 4414 Views
- Amex, I also Faced
- E-Mail Answers
Answer Posted / krish
can be implemented in Information using variable ports. think of current value and previous value
https://etltechsolutions.wordpress.com/2015/11/04/oracle-scenario/
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Where do we use mapping variables in informatica?
How to delete duplicate row using informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the types of presistent cache in look up tr.
Enlist few areas or real-time situations where informatica is required.
What is standalone command task?
How to extract sap data using informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is the difference between a repository server and a powerhouse?
How would you join a node to the already existing domain?
What is domain and gateway node?
Briefly explain the aggregator transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
Explain what is informatica metadata and where is it stored?
Do you find any difficulty while working with flat files as source and target?
