Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 12174

how DTM buffer size and buffer block size are related

Wipro,

3 31348

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

Wipro,

4 13583

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

Wipro,

3 11546

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

2 6737

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 22685

Explain about HLD and LLD ?

Accenture,

16 149148

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

Accenture,

9 27578

explain different types of modeling.

2 11355

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

4 21339

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

Accenture,

7 16819

Which kind of index is preferred in DWH?

3 12165

what is fact table?

9 13564

what is dimension table?

17 32687

what is metadata?

Satyam,

8 12613

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the different lookup cache(s)?

1113

Global and Local shortcuts. Advantages.

2032

What do you understand by SOA of Informatica?

980

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2145

generate date / time dimension in informatica

1123

explan ur project architecture?

2058

How can you differentiate between powercenter and power map?

1085

What is informatica? Why do we need it?

1092

What is the sequence generator transformation in informatica?

1178

Can we create two repositories on same database instance in oracle?

1087

What are the transformations that are not supported in mapplet?

1018

Describe an informatica powercenter?

1123

How do you load unique records into one target table and duplicate records into a different target table?

1237

What are the restrictions of union transformation?

1038

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5669

For More Un-Answered { Informatica } Questions Click Here