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
- 3406 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 |
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
HOW DO YOU CONNECT TO REMOTE SERVER ?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
What is the difference between a router and a filter transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
In a sequential batch can you run the session if previous session fails?
can you please explain me pre session and post session options?
In ur current projectu have done any performance tuning of mappings?
How can you define a transformation? What are different types of transformations in Informatica?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
What is IQD file?
Teradata 
