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

Informatica Interview Questions

Questions Answers Views Company eMail

what is diff between grep and find

IBM, iFlex,

3 11113

how can we load first and last record from a flat file source to target?

Infosys, ITC Infotech,

7 29172

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

KPIT,

1 7859

What are partitions in informatica and which one is used for better performance?

2 15879

How Union Transformation is an Active Trans?

6 20037

What is a surrogate key?Why we use it in a mapping?Pl give an example.

PCS,

4 12245

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

CSC,

3 8162

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

CSC,

10 34158

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 7460

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 18388

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 6431

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 7130

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

Infosys,

1 7617

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 10095

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 7673

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

994

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2241

What is the difference between a repository server and a powerhouse?

1417

Explain what are the different versions of informatica?

1037

What is dimensional table? Explain the different dimensions.

1114

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1230

What is a joiner transformation and why it is an active one?

1001

Performance tuning( what you did in performance tuning)

1911

What is joiner transformation?

951

Explain the types of transformations?

1008

Can u generate reports in Informatica?

1027

How do you promote a non-reusable transformation to reusable transformation?

1071

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

1062

State the differences between sql override and lookup override?

1115

What is dynamic cache?

974

For More Un-Answered { Informatica } Questions Click Here