Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

If the records doesnt satisfy the filter condition where will it go?

IBM,

10 15979

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

HCL,

7136

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

Accenture, Gcs, TCS,

119 114732

how to join two flat files in informatica?

Wipro,

3 18954

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

Wipro,

4 9316

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

Wipro,

5 9501

in what type of scenario bulk loading and normal loading we use?

Cognizant, Wipro,

2 6645

how can we run workflow with pmcmd?

Wipro,

3 8675

what is bridge tables in informatica

CTS,

1 9928

what is the -ve test case in your project.

CTS, TCS,

2353

why union transformation is active transformation?

IndiGo, TCS,

6 24040

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 7665

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.

CTS,

5 35933

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

CTS,

1 7129

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 9014

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the components of Informatica? And what is the purpose of each?

999

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1063

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1210

What is the Process to creating lookup transformation in informatica

998

In informatica workflow manager, how many repositories can be created?

1295

Explain target update override in informatica

1061

What are session parameters ? How do you set them?

1790

can anyone explain me about retail domain project in informatica?

7902

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

1976

What is an Integration service in Informatica?

1094

Explain what are the different versions of informatica?

1048

 Informatica Checkpoints

3277

what are the deliverables?in your project?

2100

Can informatica load heterogeneous targets from heterogeneous sources?

1131

What is lookup change?

1000

For More Un-Answered { Informatica } Questions Click Here