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
- 3420 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 |
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
Explain direct and indirect flat file loading (source file type) - informatica
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
what are the row and column separations in Flat Files
Is it possible to have "5 source & 5 Target" in single mapping?
How can you validate all mappings in the repository simultaneously?
task is running successfully but data is not loded why?
what are the types of Data warehousing ?
What are some examples of informatica etl programs?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
Teradata 
