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
- 4326 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 are teh different tasks that can be created in workflow manager?
can a port in expression transf be given the name DISTINCT
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
What is meant by query override?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is an Integration service in Informatica?
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?
Major difference between SQL override and Lookup Sql override
What is polling?
What are the connected or unconnected transforamations?
what are cost based and rule based approaches and what is the difference?
What is a command that used to run a batch?
Teradata 
