Sign Up Login


  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 3116

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

iGate,

3 6319

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 4648

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

TetraSoft,

4 8925

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 4967

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 4663

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 6885

Which is better performance wise database or file?How?

TCS,

2 5947

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

1 3718

How u use pdf file in informatica source?

Ericsson, HP, IBM,

2 6595

What is joiner cache?

TCS,

2 5708

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

EXL,

2 19126

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

 2 5676

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

 1 3633

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

TCS,

10 27864

Post New Informatica Questions

Un-Answered Questions { Informatica }

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1405

How we can create indexes after completing the loan process?

955

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

873

What are the transformations that are not supported in mapplet?

773

What are multi-group transformations?

771

Explain the different dimensions.

729

What is the use of target designer?

794

What is aggregator transformation in informatica?

727

Explain the code page compatibility?

823

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

892

How to do the error handling of if ur source is flatfiles?

1705

is it possible to index the data in cache of lkp transformation ?

1718

Can we create multiple integration service on single repository?

931

Enlist the advantages of informatica.

825

What is informatica powercenter repository?

909

For More Un-Answered { Informatica } Questions Click Here