What is union transformation?

965

How to do unit testing in informatica? How to load data in informatica ?

1120

To import the flat file definition into the designer where should the flat file be placed?

1059

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2075

Explain the different kinds of facts.

981

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1776

what is index?how it can work in informatica

2040

Enlist few areas or real-time situations where informatica is required.

1084

Explain why we use partitioning the session in informatica?

1090

Explain the etl program with few examples.

1048

How do you load only null records into target? Explain through mapping flow.

2021

without table how to come first record only in oracle?

2252

Under which circumstances, informatica server creates reject files?

1093

What is dimensional table? Explain the different dimensions.

1172

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

4188