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 10635

how DTM buffer size and buffer block size are related

Wipro,

3 29965

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

Wipro,

4 12014

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

Wipro,

3 10110

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

2 5679

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 18975

Explain about HLD and LLD ?

Accenture,

16 144119

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

Accenture,

9 24555

explain different types of modeling.

2 10360

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

4 19950

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

Accenture,

7 14478

Which kind of index is preferred in DWH?

3 10929

what is fact table?

9 11102

what is dimension table?

17 28558

what is metadata?

Satyam,

8 10433


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the types of data warehouses?

948


Why sorter is an active transformation?

757


COM components can be used in Informatica

1877


Explain target update override in informatica

634


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1329






How can you differentiate between powercenter and power map?

627


State the limitations where we cannot use joiner in the mapping pipeline?

553


how we can load rejected record's at run time?(not through bad files)

1913


What is incremental aggregation?

577


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10282


What are the limitations of joiner transformation?

657


Explain lookup transformation is active in informatica

665


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1907


What are the performance considerations when working with aggregator transformation?

678


In how many ways we can create ports?

706