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
- 4320 Views
- Amex, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of target designer?
what is song in infrmatica...?
What are the different versions of informatica?
What is the function of look up transformation?
whats the logic to load the lower level of granularity of data to fact table.
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What is joiner transformation?
What is sq transformation?
What are the differences between joiner transformation and source qualifier transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is substr in informatica?
What is a pre-defined event and user-defined event?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain lookup transformation source types in informatica
Partition, what happens if the specified key range is shorter and longer
