How to send duplicates to one target and unique rows to one target?target is empty9 23912
How to jion 2 tables, without using any condition?11 29833
what is the need of session partitioning... how it is useful in real time3 5955
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 Y2 6625
I 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 .898
If a=5, b=6, c=7, b+=a%c*2. What is the final value of b?
Explain the term memtable?
What do you understand by match index?
Which element is added in steel to increase resistance to corrosion ?
Explain either/left/right design pattern in scala?
What is the difficulty you have faced in the BW in your overall experience?we don't want common things,we need some difficult concepts what u have faced(in past Experience)?
What about auto-refreshing ads?
Why did ibm cognos tm1 web change the technology from .net to java?
Can you make a class selector particular to an element type?
How do you ensure that n threads can access n resources without deadlock?
What is the man difference between hbase and hive?
What is the purpose of a model?
How do I maximize seo in wordpress?
What is categories in iOS?
How to do clean up if create database failed?