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

Informatica Interview Questions

Questions Answers Views Company eMail

Quickly characterize reusable change?

1119

What do you mean by channel change?

1047

What are the measure objects?

1202

What are the different types of transformation available in informatica.

1105

Explain what are the different types of transformation available in informatica.

1149

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1079

How to do unit testing in informatica? How to load data in informatica ?

1120

Explain the different dimensions.

965

Differentiate between source qualifier and filter transformation?

1578

Explain scd type 3 through mapping.

1006

What is dimensional table?

1063

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

1581

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

1125

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

Explain in detail about scd type 1 through mapping.

1555

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is target load order?

1246

Please let me know how to make Data masking in informatica..

1722

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1248

where to store informatica rejected data?

1093

what is the hint? how to use it to reduce the query processing in program?

7835

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121

how many types of dimensions are available in informatica?

1098

What could be the possible resons of locks by user?

1094

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2075

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2323

What will be the approach?

979

Can we override a native sql query within informatica?

1036

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1995

What is flashback table ? Advance thanks

1934

For More Un-Answered { Informatica } Questions Click Here