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 9089I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
1914Post New Amazon Informatica Interview Questions
Describe how to send email from a python script?
Is it true, that there is no difference between a rule and a check constraint?
Explain the order of sql statement execution?
State all the file open modes?
Tell me how to check if number is numeric while using jquery 1.7+? : jquery mobile
How to limit the connections to from a service?
Does windows 10 use more ram than windows 7?
Do you know triggerbusinessevent is used for triggering the workflow and its written on workflow event. Triggerbusinessevent has the syntax?
Can I use exchange 2000 tools to manage exchange 2003 servers?
GIven a sequence of characters. How will you convert the lower case characters to upper case characters. ( Try using bit vector - sol given in the C lib -> typec.h)
What do you mean by collision in hashing?
What is extern objective c?
I have deleted a file from recycle bin but I want to use that file how can I restore that file? I have already used system restore for the same but the file could not berestore?
selenium can handle pop-up windows based on selenium is a test tool?
How do you load unique records into one target table and duplicate records into a different target table?