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
- 4582 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
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
According to his methodology what all you need before you build a datawarehouse
What is the fact table?
draw informatica architecture 8.6 ?
Enterprise data warehouse your projects phase by phase explain?
What is the status code in stored procedure transformation?
What is transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is lookup transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Informatica settings are available in which file?
What are the tasks that can be performed using sq?
Informatica Checkpoints
Which files are created during the session rums by informatics server?
What is a node in Informatica?
