Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9177 Views
- Amazon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What are the advantages of informatica?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
What is Datadriven?
what are the transformations that restricts the partitioning of sessions?
Filter transformation in the condition one of the data is NULL would the record be dropped.
replace multiple spaces with single space.
what is diff between grep and find
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
What is substr in informatica?
Explain the difference between a data warehouse and a data mart?
without using rank transformation how can we rank items by using some other transformations
What are the join types in joiner transformation?
Teradata 
