Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z




Amazon Informatica Interview Questions
Questions Answers Views Company eMail

How to send duplicates to one target and unique rows to one target?target is empty

 9 23469

How to jion 2 tables, without using any condition?

 11 29257

what is the need of session partitioning... how it is useful in real time

 3 5815

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 6397

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 .

 847

Post New Amazon Informatica Interview Questions




Amazon Informatica Interview Questions





Un-Answered Questions

How does jcl act on a cobol code?

30

what is paradoxing in neworking

1600

What type of paper when made into a paper boat floats longest?

44

Tell me what is database migration? And how to use it to add insert initial data to database?

16

What are fragments?

11




How do I make my computer type what I say?

7

What is corba good for?

22

How do you put a background on powerpoint 2007?

2

Explain how old is this universe?

5

What is the advantage of using #define to declare a constant?

42

What are the translations available in Drupal?

3

What is substr function?

47

SQL How can make delete and insert in one query

896

What is element of computer?

8

How to configure the integration of pp and pm, where it is being done in spro, what are the pre-requisite and what are the steps?

48