1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

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

iGate, TCS,

1 2846

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

iGate,

3 5834

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 4323

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

TetraSoft,

4 8361

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 4548

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 4292

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 6569

Which is better performance wise database or file?How?

TCS,

2 5536

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

1 3411

How u use pdf file in informatica source?

Ericsson, HP, IBM,

2 6193

What is joiner cache?

TCS,

2 5151

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

EXL,

2 18646

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

 2 5267

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

 1 3300

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

TCS,

10 26257

Post New Informatica Questions

Un-Answered Questions { Informatica }

Partition, what happens if the specified key range is shorter and longer

2031

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

601

What are the performance considerations when working with aggregator transformation?

678

Define the various join types of joiner transformation?

561

How to open an older version of an object in the workspace?

620




Different qualification between a related rotate toward the sky and isolates look upward?

556

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1699

What is a surrogate key?

563

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

656

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1697

What is flashback table ? Advance thanks

1482

Repository user profiles

1377

How can you validate all mappings in the repository simultaneously?

762

What is a difference between complete, stop and abort?

643

During the running session, output files are created by informatica server. Enlist few of them.

546

For More Un-Answered { Informatica } Questions Click Here