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 5515I 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 .
572Post New Amazon Informatica Interview Questions
What else ? This is the question asked to me every where every time while facing interview. I want to know is this a real question for accounting? If yes haw or if no How? I am really confuse.
What is the pros and cons between QTP and Rational Robot
which is the latest version of dos? & what is the command to copy windows files (i386) without formatting OS?
Please tell me any one, how many quantity concrete paver block fixing perday ( 8hours) per mason??
how to calculate power consumption in slip ring motor at different step
Distinguish value andPrice
Please, anyone out there that had been a SQA Tester, would You all give me a hint on this Job? Is becoming a SQA Tester is easy? Is it a tough one? Please help me on finding a way on this very first Job of mine?
can any one send me previous ntpc exam papers at garima.12g@gmail.com?
We use MCCB not MCB for motor starters because MCCBs has capablity to drawout the motor starting current which is 5-6 times the full load current of motor for 1sec. Then why we use SDF in starter panel means MCC panels. Pls reply if any one knows this answer.
I want some common questions which have been asked in interviews of NTPC Limited,Satluj Jal Vidyut Nigam Ltd.,and Bharat Heavy Electricals Ltd.
Explain about Brucella LPS extraction ?
10.Define filters,binary to hexadecimal,hexadecimal to decimal?
Advantage of LT panel vs HT panel
Stator of 3-phase IM has 3 slots per pole per phase. If supply frequency is 50 Hz, calculate the speed of rotating stator flux A 1000 rpm B 500 rpm C 1500 rpm D 1440 rpm
How to Create NonMaintained or .NDX indexes on dBASE Tables?
- C (5)
- OOPS (2)
- C++ General (2)
- PHP (2)
- Programming Languages AllOther (1)
- VB Script (7)
- Shell Script (4)
- ASP.NET (2)
- Oracle General (2)
- Database Management (1)
- Unix Commands (6)
- Unix AllOther (1)
- Data Structures (2)
- Automation Testing AllOther (1)
- Manual Testing (7)
- Test Cases (2)
- Testing AllOther (2)
- Core Java (2)
- J2EE (1) Informatica (5)
- HR Questions (4)
- Encryption Decryption (1)
- Requirement Management (1)
- Mechanical Engineering (1)
- Electrical Engineering (2)
- Engineering AllOther (1)
- Banking Finance (2)
- IT Management (1)
- CompanyAffairs CS (1)
- Accounting General (5)
- Accounting AllOther (6)
- Call Centre AllOther (32)
- RRB (1)
- NDA (1)
- Everything Else AllOther (2)
- English (1)
- General Aptitude (7)
- Puzzles (6)
- Placement Papers (1)
- CCNA (1)
- C Code (4)
- C++ Code (1)
- C C++ Errors (1)
