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 5169

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 11986

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,

2263

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

Syntel,

4 23389

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

Syntel,

3 9086

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

Syntel,

2129

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,

2580

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 6940

what is data driven?

1 3967

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 8365

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

HTC, TCS,

1 8625

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the designer tools for creating transformations?

1118

What are the performance considerations when working with aggregator transformation?

1152

How we can create indexes after completing the load process?

1160

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1665

Differentiate between a repository server and a powerhouse?

1118

what is diff b/t sorter t/r and agg have the option sorter property...

2179

differences between service based and product based?

2015

Differentiate between router and filter transformation?

1012

Implementation methodology

1714

What is update strategy transform?

1104

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2077

What are the features of complex mapping?

1161

How can one identify whether mapping is correct or not without connecting session?

1451

How would you copy the content of one repository to another repository?

1019

What is transformation?

1099

For More Un-Answered { Informatica } Questions Click Here