Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 12017

how DTM buffer size and buffer block size are related

Wipro,

3 31188

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

Wipro,

4 13438

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

Wipro,

3 11437

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

2 6635

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 22288

Explain about HLD and LLD ?

Accenture,

16 148599

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

Accenture,

9 27277

explain different types of modeling.

2 11242

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

4 21179

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

Accenture,

7 16561

Which kind of index is preferred in DWH?

3 12041

what is fact table?

9 13289

what is dimension table?

17 32230

what is metadata?

Satyam,

8 12339


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is an aggregator transformation?

1036


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2233


Explain what is informatica metadata and where is it stored?

998


What is informatica etl tool?

952


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2064


Can we get 1st record through Informatica(without sequence number).

1417


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1226


Difference between Data and Index Caches?

1101


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1983


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7328


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

1093


Name the different lookup cache(s)?

1168


Differentiate between a repository server and a powerhouse?

1058


Differentiate between reusable transformation and mapplet.

1040


Describe data concatenation?

1017