Informatica interview questions – page 5

How union transformation is active ?

In bankingdomain projects how many facttables are there?

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

Hi I have two sources like A, B. My source A contain 10000million records from that i need 20 attributes. My source Bhas also same 10000 million records from that i need only 1attribute. By using Joiner i have to load into target? Isthere any issue regarding this? if issue is there how totune this mapping in best way?

Name few built in sas transformation in DI studio ?

Can we use union transformation in joiner transformation?how?

How to display last 5 records in a table ? With out Top key word and doing order by descAdvance thanks

Which transformation uses cache?

What is the difference between look up and joiner(don't sayjoiner sopport only = where as look up support non-equijoin).

What is checksum termnology in informatica? Where do you useit ?

What is source qualifier?

How to call lookup qualifer in unconnected look;up

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

Select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

What is the difference between filter and lookup transformation?

Compare Data Warehousing Top-Down approach with Bottom-up approach

Explain the informatica Architecture in detail

Difference between summary filter and details filter?

What is surrogatekey ? In ur project in which situation u has used ? explain with example ?

If a session fails after loading of 10,000 records in to the target.How can u load the records from 10001 th record when u run the session next time in informatica 6.1?

Discuss the advantages & Disadvantages of star & snowflake schema?

Is sorter an active or passive transformation? What happens if we uncheck the distinct option in sorter.Will it be under active or passive transformation?

How to define Informatica server?

What are the difference between view and materialized view?

To provide support for Mainframes source data,which files are used as a source definitions?

Suppose session is configured with commit interval of 10,000 rows and source has 50,000 rows. Explain the commit points for Source based commit and Target based commit. Assume appropriate value wherever required.

What is tracing level?

Discuss which is better among incremental load, Normal Load and Bulk load

At the max how many tranformations can be us in a mapping?

What does the expression n filter transformations do in Informatica Slowly growing target wizard?