Informatica Interview Questions
Questions Answers Views Company eMail

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

Wipro,

4 10546

how DTM buffer size and buffer block size are related

Wipro,

3 29877

how much memory (size) occupied by a session at runtime

Wipro,

4 11921

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

Wipro,

3 9992

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 5625

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

Accenture,

11 18737

Explain about HLD and LLD ?

Accenture,

16 143728

how u know when to use a static cache and dynamic cache in lookup transformation.

Accenture,

9 24351

explain different types of modeling.

2 10278

what is shared Cache. when we will use shared Cache?

4 19823

whether Sequence generater T/r uses Caches? then what type of Cache it is

Accenture,

7 14349

Which kind of index is preferred in DWH?

3 10842

what is fact table?

9 10965

what is dimension table?

17 28312

what is metadata?

Satyam,

8 10251


Post New Informatica Questions

Un-Answered Questions { Informatica }

What the difference is between a database, a data warehouse and a data mart?

572


In development project what is the process to follow for an etl developer from day1

1259


Explain joiner transformation in informatica

648


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

1483


how tokens will generate?

1712






What are the tasks that can be performed using sq?

590


What is a difference between complete, stop and abort?

617


What are the data movement modes in informatica?

679


What is intricate mapping?

564


differences between service based and product based?

1546


To import the flat file definition into the designer where should the flat file be placed?

652


What is a grid in Informatica?

593


draw informatica architecture 8.6 ?

3446


How to load the data from people soft hrm to people soft erm using informatica?

533


What is primary and backup node?

666