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
- 4586 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 |
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 are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain sessions. Explain how batches are used to combine executions?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
list out all the transformations which use cache?
explain about unit testing? in real time?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
what is plsql table?
what is curr val use for in sequence generator?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
Difference Between ETL & ELT?
Hi All can anyone tell me where i will get Informatica training in Mumbai?
Teradata 
