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
Answer Posted / jd
this can be done using FIRST_VALUE() AND LAST_VALUE()
check the below link for more information
http://netezzamigration.blogspot.com/2014/10/lastvalue-and-firstvalue-best-example.html
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are junk dimensions?
What is data caches/ index caches?
What are active and passive transformations?
What are the new features of informatica 9.x developer?
What is the different lookup cache(s)?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is data movement mode in Informatica and difference between them?
what is unit testing?tell me proceedure
How do we call shell scripts from informatica?
What is a mapplet/worklet in informatica?
Define joiner transformation?
Enlist the differences between database and data warehouse.
Explain the use of aggregator cache file?
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the types of lookup transformation?