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
- 3454 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 |
what is the difference between copy object import objects using repositery manager which one is best
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
what is metadata?
How will you display "Mr" for male & "Mrs" for female in target table?
which one is better performance wise joiner or look up
What is the function of aggregator transformation?
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
Did u used latest transformations of 8.6.0? for what?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
what is surrogate id ?
what is the difference between stop and abort
How many repositories can we create in Informatica?
Teradata 
