Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 8919

how DTM buffer size and buffer block size are related

Wipro,

3 27743

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

Wipro,

4 10039

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

Wipro,

3 8371

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

2 4857

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 15055

Explain about HLD and LLD ?

Accenture,

16 135101

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

Accenture,

9 20172

explain different types of modeling.

2 9157

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

4 17457

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

Accenture,

7 11518

Which kind of index is preferred in DWH?

3 9188

what is fact table?

9 8719

what is dimension table?

17 24074

what is metadata?

Satyam,

8 7722


Post New Informatica Questions






Un-Answered Questions { Informatica }

What is complex mapping?

163


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

1275


What are the different clients of powercenter?

144


Design time, run time. If you don't create parameter what will happen

966


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

216






What is the maplet?

178


How many numbers of sessions can one group in batches?

159


Write the unconnected lookup syntax and how to return more than one column.

133


How would you copy the content of one repository to another repository?

164


What are the tasks that can be performed using sq?

153


4 yrs etl devloper roles and responsibilities?any body give solutions

1072


Where is metadata stored?

148


What is enterprise data warehousing?

144


What are pre and post-session shell commands?

148


What are the different lookup cache(s)?

174