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 5167

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 11984

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,

2261

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

Syntel,

4 23383

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

Syntel,

3 9084

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

Syntel,

2127

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

Syntel,

2 8015

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 14276

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 7290

Is there any target staging area in informatica not staging area

Syntel,

2578

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

IBM,

1 3614

why we are using level option in normalizer transformation

TCS, Wells Fargo,

1 6938

what is data driven?

1 3962

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 8359

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

HTC, TCS,

1 8622

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is different between the data warehouse and data mart?

1066

What is flashback table ? Advance thanks

1934

Differentiate between sessions and batches?

1018

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8202

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012

Define the various join types of joiner transformation?

988

Explian the Process of deployment groups in informatica

1062

Design time, run time. If you don't create parameter what will happen

1837

Explain Dataware house architecture .how data flow from intial to end?

2584

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036

What are the different lookup cache(s)?

1118

what is song in infrmatica...?

2237

What is the use of an aggregator cache file?

1199

What are the performance considerations when working with aggregator transformation?

1152

Explain what transformation and how many are there in informatica?

955

For More Un-Answered { Informatica } Questions Click Here