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
- 4423 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 |
Is informatica power center designer has 64 bit support?
whatis the default data driven operation in informatica
What is the default join that source qualifier provides?
How can we create index after completion of load process?
what is system requirement(SR) & business requirement(BR)?
How many ways a relational source definition can be updated and what are they?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
How do you load alternate records into different tables through mapping flow?
How will you combine 3 different sources with a single source?
How the dimensions will be loaded?
Which means the first record should come as last record and last record should come as first record and load into the target file?
In informatics server which files are created during the session rums?
Teradata 
