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

Informatica Interview Questions

Questions Answers Views Company eMail

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 5275

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

IBM,

6 12207

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?

TCS,

2314

Can we insert and update a target table without using update strategy transformation?How?

Syntel,

4 23571

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

Syntel,

3 9242

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

Syntel,

2216

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

Syntel,

2 8133

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

Syntel,

3 14425

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

Accenture,

2 7421

Is there any target staging area in informatica not staging area

Syntel,

2634

How to fix the etl bugs..Tell me the process?

IBM,

1 3695

why we are using level option in normalizer transformation

TCS, Wells Fargo,

1 7028

what is data driven?

1 4054

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

TCS,

4 8518

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

HTC, TCS,

1 8716

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are session parameters ? How do you set them?

1901

What are the different versions of informatica?

1338

On which transformations you created partitions in your project?

1441

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

2155

What is the difference between informatica 7.0 and 8.0?

1054

What is the difference between router and filter?

1380

What are the differences between a connected lookup and unconnected lookup?

1128

What is a surrogate key?

1161

Differences between connected and unconnected lookup?

1273

How to join three sources using joiner? Explain though mapping flow.

1193

Explain the difference between a data warehouse and a data mart?

1113

What is dimensional table?

1135

Explain the different lookup methods used in informatica?

1098

Write the unconnected lookup syntax and how to return more than one column.

1157

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2405

For More Un-Answered { Informatica } Questions Click Here