Informatica Interview Questions
Questions Answers Views Company eMail

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 11566

How can you change from reusable session into non-reusable session.

Cap Gemini,

5 40057

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

TCS,

8 7738

I want load the data into target with out 1st and last record.

Yash Technologies,

5 8277

What is polling in informatica ?

TCS,

1 11095

how to delete duplicate records by using filter transfermation?

3 6749

what is unit testing?tell me proceedure

L&T, UST,

1752

Tell me one complex query in oracle ?

L&T, Satyam,

2 6811

How to delete the data in the target table after loaded.

TCS,

3 7811

How can you display only hidden files in UNIX

Cognizant, L&T,

4 8832

what is diff b/t sorter t/r and agg have the option sorter property...

1712

How to delete the (flat file) data in the target table after loaded.

TCS,

2 6594

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1848

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

TCS,

2 5932

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

Patni,

1708


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1610


Differentiate between joiner and lookup transformation?

591


What is the need of etl tools?

579


Briefly describe lookup transformation?

580


How is union transformation utilized?

546






explain one complex mapping with logic? sales project?

6098


Difference between Data and Index Caches?

628


How can you define user defied event?

595


what are the Methods For Creating Reusable Transformations?

619


Can you generate sequence numbers without using the sequence generator transformation?

576


What is the need of an ETL tool?

616


What is InformaticaPowerCenter?

662


Explain the types of lookup transformation?

539


what is informatica metadata?

574


How can we update a record in the target table without using update strategy?

620