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
- 4318 Views
- Amex, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Name 4 output files that informatica server creates during session running?
What is meant by pre and post session shell command?
What are the data movement modes in informatica?
whats the logic to load the lower level of granularity of data to fact table.
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
have you developed documents in your project? and what documents we develop in realtime?
Can a joiner be used in a mapplet.
what is the difference between mapplet & stored procedure?
Types of error logs in Informatica?
What are the components of Informatica? And what is the purpose of each?
What do think which one is the better joiner or look up?
What is the filename which you need to configure in UNIX while installing infromatica?
Teradata 
