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 11308

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

Infosys, ITC Infotech,

7 29426

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 7942

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

2 16013

How Union Transformation is an Active Trans?

6 20286

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

PCS,

4 12427

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 8352

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

CSC,

10 34516

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

5 7660

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

7 18759

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 6581

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 7275

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

Infosys,

1 7694

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

5 10283

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 7808

Post New Informatica Questions

Un-Answered Questions { Informatica }

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237

What are the performance considerations when working with aggregator transformation?

1152

What are the various types of transformation?

1179

What is Cognos script editor?

4229

Explain transaction control transformation in informatica

1268

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1581

Define joiner transformation?

1049

How do you load only null records into target?

1216

What are the types of schemas we have in data warehouse.

963

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2261

How can you differentiate between powercenter and power map?

1088

How to configure mapping in informatica?

1173

how many types of dimensions are available in informatica?

1098

How can we store previous session logs?

1080

How many number of sessions can one group in batches?

1157

For More Un-Answered { Informatica } Questions Click Here