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 11451

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

Infosys, ITC Infotech,

7 29680

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 8047

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

2 16132

How Union Transformation is an Active Trans?

6 20518

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

PCS,

4 12577

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 8481

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

CSC,

10 34854

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

5 7851

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

7 19011

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 6705

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 7423

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

Infosys,

1 7805

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

5 10464

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 7883

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1019

What is the Rank index port in Rank transformation?

1105

How can we create index after completion of load process?

1168

What is the way to execute pl/sql script using informatica mapping?

1682

Differentiate between a database and data warehouse?

1194

Can anyone tell me the new features in Informatica 9 Version?

2216

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1155

Different circumstance which drives informatica server to expel records?

1047

What are the restrictions of union transformation?

1090

Explain the mapping variable usage example in informatica

1225

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4152

What is the maplet?

1206

What is an expression transformation in informatica?

1094

How to generate sequence numbers using expression transformation?

1152

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1962

For More Un-Answered { Informatica } Questions Click Here