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
- 4412 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
What is event and what are the tasks related to it?
tell me 5 session failure in real time how can you solve that in your project?
How can we store previous session logs?
How many ways are there to create ports?
what are the deliverables?in your project?
What are mapplets? How is it different from a Reusable Transformation?
Explain about Informatica server process that how it works relates to mapping variables?
Enlist the advantages of informatica.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
list out all the transformations which use cache?
What are the tasks that can be performed using sq?
What is meant by target load plan?
What is the cumulative sum and moving sum?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
