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 9258I 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 .
1986Post New Amazon Informatica Interview Questions
- Amazon C Interview Questions (12)
- Amazon C++ Interview Questions (30)
- Amazon STL Interview Questions (1)
- Amazon OOPS Interview Questions (2)
- Amazon C++ General Interview Questions (9)
- Amazon PHP Interview Questions (2)
- Amazon Programming Languages AllOther Interview Questions (14)
- Amazon VB Script Interview Questions (7)
- Amazon Shell Script Interview Questions (5)
- Amazon C Sharp Interview Questions (4)
- Amazon ASP.NET Interview Questions (5)
- Amazon Dot Net General Interview Questions (2)
- Amazon Oracle General Interview Questions (2)
- Amazon SQL Server Interview Questions (1)
- Amazon SQL PLSQL Interview Questions (1)
- Amazon Database Management Interview Questions (4)
- Amazon Databases AllOther Interview Questions (8)
- Amazon Linux General Interview Questions (1)
- Amazon Linux AllOther Interview Questions (1)
- Amazon Unix Commands Interview Questions (7)
- Amazon Unix AllOther Interview Questions (2)
- Amazon Data Structures Interview Questions (3)
- Amazon Automation Testing AllOther Interview Questions (1)
- Amazon Manual Testing Interview Questions (7)
- Amazon Test Cases Interview Questions (3)
- Amazon Testing AllOther Interview Questions (2)
- Amazon Core Java Interview Questions (30)
- Amazon J2EE Interview Questions (1)
- Amazon Java Related AllOther Interview Questions (3) Amazon Informatica Interview Questions (5)
- Amazon HR Questions Interview Questions (120)
- Amazon OOAD Interview Questions (1)
- Amazon AI Algorithms Interview Questions (1)
- Amazon Data Science Interview Questions (9)
- Amazon Encryption Decryption Interview Questions (1)
- Amazon Requirement Management Interview Questions (1)
- Amazon Amazon Web Services (AWS) Interview Questions (19)
- Amazon Cloud Computing General Interview Questions (1)
- Amazon Civil Engineering Interview Questions (1)
- Amazon Mechanical Engineering Interview Questions (1)
- Amazon Electrical Engineering Interview Questions (3)
- Amazon Power Plant Engineering Interview Questions (1)
- Amazon Engineering AllOther Interview Questions (1)
- Amazon Banking Finance Interview Questions (2)
- Amazon IT Management Interview Questions (1)
- Amazon CompanyAffairs CS Interview Questions (1)
- Amazon Accounting General Interview Questions (5)
- Amazon Accounting AllOther Interview Questions (7)
- Amazon Call Centre AllOther Interview Questions (35)
- Amazon RRB Interview Questions (1)
- Amazon NDA Interview Questions (1)
- Amazon Everything Else AllOther Interview Questions (2)
- Amazon English Interview Questions (1)
- Amazon General Aptitude Interview Questions (17)
- Amazon Puzzles Interview Questions (6)
- Amazon Placement Papers Interview Questions (1)
- Amazon CCNA Interview Questions (1)
- Amazon C Code Interview Questions (4)
- Amazon C++ Code Interview Questions (1)
- Amazon J2EE Code Interview Questions (1)
- Amazon C C++ Errors Interview Questions (1)
Which are the 3 types of transactions manager wcf supports?
Give me one example of a functional specification and explain what information we will get from that?
What are the transaction codes or t-codes for info-objects?
how to individual capital account.
iam an electronics & comm engg student.i have applied for AAI can u please forward the old and related question papers to my id lali.ece63@gmail.com
Why does my code get a security exception when I run it from a network shared drive?
What is the most ductile metal?
What is rollup component?
Tell us about spring security.
is LE module is better than SD module to get a job in SAP? becouse i think sd consultant are more than LE is it?
How do you know if windows is corrupted?
What are the reasons behind the development works in joomla?
especeted cutt off for bharat electronics limited exam both on 26june and 1 july
What are the components of embedded system?
Can you list some of the popular consensus algorithms?
