Consider a Phone Log table as below. It records all phone numbers that we dial in a given day.
SOURCE_PHONE_NUMBER
DESTINATION_PHONE_NUMBER
CALL_START_DATETIME
1234
4567
01/07/2011 10:00
1234
2345
01/07/2011 11:00
1234
3456
01/07/2011 12:00
1234
3456
01/07/2011 13:00
1234
4567
01/07/2011 15:00
1222
7890
01/07/2011 10:00
1222
7680
01/07/2011 12:00
1222
2345
01/07/2011 13:00
Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different.
Desired Output:
Source Number
Is_Match
1222
N
1234
Y
- 2 Answers
- 8295 Views
- Amazon, I also Faced
- E-Mail Answers
Answer Posted / kivi
first value and last value...
for more info ref
http://etltechsolutions.wordpress.com/2014/10/12/last_value-and-first_value-best-example/
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what is song in infrmatica...?
What are the new features of informatica 9.x at the developer level?
What is transformation?
How can we improve session performance in aggregator transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is a code page?
Explain the scenario which compels informatica server to reject files?
Different qualification between a related rotate toward the sky and isolates look upward?
How to elaborate tracing level?
what are 3 tech challenges/ common issues you face?
What is resilience time?
How are the sources and targets definitions imported in informatica designer?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain what is informatica metadata and where is it stored?
