this can be done using FIRST_VALUE() AND LAST

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

Question Posted / jd

2 Answers
9152 Views
Amazon, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Explain the different kinds of facts.

978

Clarify the aggregator change?

1021

Can we create two repositories on same database instance in oracle?

1087

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2118

Separate from a database, an information bazaar, and an information stockroom?

1084

On which transformations you created partitions in your project?

1343

What is union transformation?

962

What are the types of caches in lookup?

1048

What is meant by lookup transformation?

1100

How many numbers of sessions can one group in batches?

1061

What are the new features of informatica 9.x in developer level?

995

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1038

What is the use of an aggregator cache file?

1199

What are the tuning techniques you applied during your last project

2022

Explain the scenario which compels informatica server to reject files?

1163