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 16302

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,

7186

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

Accenture, Gcs, TCS,

119 117538

how to join two flat files in informatica?

Wipro,

3 19124

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

Wipro,

4 9486

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 9691

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

Cognizant, Wipro,

2 6755

how can we run workflow with pmcmd?

Wipro,

3 8826

what is bridge tables in informatica

CTS,

1 10000

what is the -ve test case in your project.

CTS, TCS,

2407

why union transformation is active transformation?

IndiGo, TCS,

6 24227

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 7785

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 36195

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

CTS,

1 7209

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 9177

Post New Informatica Questions

Un-Answered Questions { Informatica }

Can you generate sequence numbers without using the sequence generator transformation?

1119

What do you mean by blocking transformation?

1037

What are the new features of informatica 9.x at the developer level?

1042

Is there any target staging area in informatica not staging area

2578

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1125

how tokens will generate?

2204

How are the sources and targets definitions imported in informatica designer?

1107

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2146

What is the difference between informatics 7x and 8x and what is latest version?

1085

What is a difference between complete, stop and abort?

1083

Explain the pipeline partition with real time example?

1143

Tell me about MD5 functions in informatica

929

What are the new features of informatica 9.x developer?

970

What you know about transaction control transformation?

994

If informatica has its scheduler why using third party scheduler?

1268

For More Un-Answered { Informatica } Questions Click Here