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

Informatica Interview Questions

Questions Answers Views Company eMail

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

Wipro,

1 7238

Issue with Update override at Target table in Informatica.

2 8699

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

DELL, TCS,

5 13047

Hi experts, can anyone tell how much we use plsql in real time

3 6793

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

Infotech,

2 9227

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 5815

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

BRAD, TCS,

8 12589

In target table how to display the system time

1 4678

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

IBM,

1 4018

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

IBM,

3 6971

what is correlated query?

IBM,

2 5867

what is inline view?

IBM,

1 5324

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

PayPal,

2 15951

what is data driven in update strategy transformation?

HCL, PayPal,

2 17278

what is system requirement(SR) & business requirement(BR)?

Ness Technologies,

2 6598

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the designer tools for creating transformations?

1112

Mention few power centre client applications with their basic purpose?

943

Repository user profiles

1758

What are the differences between oltp and olap?

969

How do you load alternate records into different tables through mapping flow?

1850

What are ETL Tools?

1111

What are the limitations of joiner transformation?

1105

How is union transformation utilized?

1005

What is a stored procedure transformation?

1049

What does update strategy mean, and what are the different option of it?

1087

How can you validate all mappings in the repository simultaneously?

1363

How to extract the informatica rejected data?

1217

Difference between Target-based loading and constraint-based loading?

995

What is target designer and target load order?

1101

What is expression transformation?

1089

For More Un-Answered { Informatica } Questions Click Here