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 3498

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

iGate,

3 6841

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 5086

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

TetraSoft,

4 9744

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 5434

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 5099

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 7252

Which is better performance wise database or file?How?

TCS,

2 6599

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

1 4079

How u use pdf file in informatica source?

Ericsson, HP, IBM,

2 7197

What is joiner cache?

TCS,

2 6599

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

EXL,

2 19816

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

2 6174

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

1 4010

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

TCS,

10 29673

Post New Informatica Questions

Un-Answered Questions { Informatica }

Why is sorter an active transformation?

1123

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9815

How to extract sap data using informatica? What is abap? What are idocs?

1176

Where are the source flat files kept before running the session?

1068

What are the types of schemas we have in data warehouse and what are the difference between them?

939

What is the difference between Active and Passive transformation?

1149

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2069

How can you increase the performance in joiner transformation?

1183

What happens when a session fails and you click on recover?

1116

How can we handle two sessions in informatica?

1029

What is expression transformation?

1089

Is there any way to read the ms excel datas directly into informatica?

1021

How does a rank transform differ from aggregator transform functions max and min?

1200

What is the status code in stored procedure transformation?

1180

What is resilience time?

1130

For More Un-Answered { Informatica } Questions Click Here