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
- 4319 Views
- Amex, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How many dimensions are there in informatica?
What is depict expression change?
How identifying bottlenecks in various components of informatica and resolving them?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
how tokens will generate?
What could be the possible resons of locks by user?
What is complex mapping?
State the limitations where we cannot use joiner in the mapping pipeline?
What does refresh system mean, and what are its distinctive choice?
What is the meaning of up gradation of repository?
Does an informatica transformation support only aggregate expressions?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is workflow monitor?
What is update strategy transform?
