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

Informatica Interview Questions

Questions Answers Views Company eMail

what are the challenge face in u r project?explain me

iGate, TCS,

1 3415

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

iGate,

3 6699

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 5005

how remove 1st 3 records & last 3 records in informatics

TetraSoft,

4 9551

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

TCS,

2 5301

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

TCS,

1 4996

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

TCS,

1 7149

Which is better performance wise database or file?How?

TCS,

2 6468

Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 4002

How u use pdf file in informatica source?

Ericsson, HP, IBM,

2 7103

What is joiner cache?

TCS,

2 6409

What is use of batch file in informatica? How many types of batch file in informatica?

EXL,

2 19667

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 6039

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 3921

How can i send first half of the records to one target and Remaining to other target?

TCS,

10 29264

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1064

What are the new features of informatica 9.x at the developer level?

985

What is informatica metadata and where is it stored?

932

What is the difference between STOP and ABORT options in Workflow Monitor?

1177

What is the maplet?

1040

What is a filter transformation?

987

Explain the types of lookup transformation?

978

What is event and what are the tasks related to it?

1054

What is workflow monitor?

997

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2224

What are the tasks that can be performed using sq?

1024

What is the format of informatica objects in a repository?

973

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1895

What is rank transformation in informatica

1108

can u any challenge your project?

1972

For More Un-Answered { Informatica } Questions Click Here