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 9313I 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 .
1 2020Post New Amazon Informatica Interview Questions
Sir, I have applied for the of Jr.engineer(Electrical & Electronics) & ASST. LOCO PILOT at ALL RRB BOARDS. please send me all RRB Boards solved papers in the year of 2001 tO till date. i requested send me the papers to my id as soon as possible (jet_0991@yahoo.com). (This is very urgent) Thank You,
IF i have two columns in Database , While using Database output value ,allthe values in the two column are set as a single row in the QTP datatable, can u suggest me a idea so that QTP Runtime datatable displays the values as it is in the database
my question is that i want help 2-5-2010 on this date i have to go for interview and written test for og-111 officer post in national bank .any budy guide me which type of question comes into test from which web i get question and prepairation for test please if any body have any i dea than email me on this email adress tufail_memon4u@hotmail.com thanks
how many reports have u created ? explain a few.
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
Draw a SLD for main panel for school having connected load of 1200kw and emergency generator 200kw.also show the increase of additional load of chiller 225kw in the lv panel indicating meter postion size of transformer ,cables and capacitor bank.
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...
Explain how to change the port of the orbix notification service?
How your supervisor describe you?
How to Retrieve the line number that a memo's cursor is on?
sir ,,kindly provide me 10 year old solved question papers of gate ,i am from CS. branch...
Explain how to generate iqd file from framework manager?
Provide examples of industries where fairness in AI is particularly critical.
Tell me about your work experience? How has it prepared you for a career at Capital One?