Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

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

iGate, TCS,

1 2543

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

iGate,

3 5390

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 3892

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

TetraSoft,

4 7672

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 4134

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 3938

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 6258

Which is better performance wise database or file?How?

TCS,

2 5136

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

1 3059

How u use pdf file in informatica source?

Ericsson, HP, IBM,

2 5632

What is joiner cache?

TCS,

2 4547

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

EXL,

2 18076

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

2 4871

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

1 3020

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

TCS,

10 23572


Post New Informatica Questions

Un-Answered Questions { Informatica }

can we override a native sql query within informatica? Where do we do it?

449


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

572


How can you generate reports in informatica?

425


Explain the etl program with few examples.

392


What are the types of data warehouses?

791






What is meant by pre and post session shell command?

447


What is primary and backup node?

525


What is exclusive and normal mode for repository services?

469


Can informatica load heterogeneous targets from heterogeneous sources?

495


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

1362


What is the advantage of informatica?

459


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1515


How to join three sources using joiner?

398


What are Dimensional table?

460


What is native users?

565