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

CTS Informatica Interview Questions
Questions Answers Views Company eMail

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 6436

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 6783

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 10934

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 9538

what is bridge tables in informatica

1 7542





what is the -ve test case in your project.

1221

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 30586

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 5322

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

3210

what is song in infrmatica...?

1146

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 6860

normalizer transformation

3 4432

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 4945

What are the issues you have faced in your project? How did you overcome those issues?

1390

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1094

Post New CTS Informatica Interview Questions




CTS Informatica Interview Questions


Un-Answered Questions

Write a program to show the purpose of literal result element?

80


How many action classes can be used in struts application?

49


what are the uses of general authorization checks?

112


Describe the programming model of a windows service

77


Is there a 64 bit version of ssms?

56






What is the use of session in hibernate?

1


Define the types of validation?

78


What is a lazy var in swift?

44


What the different components in replication and what is their use? : sql server DBA

93


What is use of material type unbw?

113


Can you use vlookup across multiple columns?

1


What is action query?

44


What is the difference between mitsui man and hitachi man.

101


What is the implicit cursor in oracle?

93


What is pivot table?

1