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

Informatica Interview Questions

Questions Answers Views Company eMail

disable caching in a lookup transformation?

1 2463

In any project how many mappings they will use(minimum)?

1 2977

How do you implement unconn. Stored proc. In a mapping?

1 2767

Can you access a repository created in previous version of Informatica?

1 2703

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 2853

How big was your fact table

1803

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 3510

How will you convert rows into columns or columns into rows

1 2685

What are the steps involved in the migration from older version to newer version of Informatica Server?

2107

What are the main features of Oracle 8i with context to datawarehouse?

2112

What are the new features of Power Center 5.0?

1778

How to run a session, which contains mapplet?

1 3998

Differentiate between Load Manager and DTM?

2153

What are session parameters ? How do you set them?

1849

When do you use mapping parameters? (In which transformations)

1 4043

Post New Informatica Questions

Un-Answered Questions { Informatica }

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1494

What is olap (on-line analytical processing?

1069

What is the maplet?

1118

How do you load only null records into target?

1216

permutations of mapplet

2511

What is Data Caches size?

1091

Explain what is informatica metadata and where is it stored?

1049

Which are the different editions of informatica powercenter that are available?

1034

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1975

Plz can any one say me how to get the informatica certification materials and dumps

2048

Enterprise data warehouse your projects phase by phase explain?

1921

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

2125

difference between informatica 8.1.1 and 8.6

3677

explan ur project architecture?

2067

Parameter and variable differences

2061

For More Un-Answered { Informatica } Questions Click Here