Informatica

What is up date strategy

What is up date strategy?
Full details

What are different types of transformations

What are different types of transformations in Informatica ? ...
Full details

What is tracing level

What is tracing level ?...
Full details

What is difference between dimension table

What is difference between dimension table and fact table ? ...
Full details

What are the tasks that Load manger

What are the tasks that Load manger process...
Full details

What is data merging, data cleansing

What is data merging, data cleansing and sampling ? ...
Full details

What are the connected or unconnected

What are the connected or unconnected transformations ? ...
Full details

How to create single lookup transformation

How to create single lookup transformation using multiple ...
Full details

What are the Differences between connected

What are the Differences between connected and unconnected ...
Full details

What is the difference between view

What is the difference between view and materialized view ? ...
Full details

How to recover sessions in concurrent

How to recover sessions in concurrent batches ? ...
Full details

How can we eliminate duplicate rows

How can we eliminate duplicate rows from flat file ? ...
Full details

What is default transformation for the

What is default transformation for the look up function ? ...
Full details

How many repositories can we create

How many repositories can we create in Informatica ? ...
Full details

Which circumstances that Informatica server

Which circumstances that Informatica server creates Reject files ? ...
Full details

What are the new features in Informatica

What are the new features in Informatica 5.0 ? ...
Full details

What are two types of processes that

What are two types of processes that Informatica runs the session ? ...
Full details

What are mapping parameters and variables

What are mapping parameters and variables in Informatica ? ...
Full details

What are the differences between joiner

What are the differences between joiner transformation and source qualifier transformation ? ...
Full details

How to complete unrecoverable sessions

How to complete unrecoverable sessions ? ...
Full details

What is the difference between Normal

What is the difference between Normal load and Bulk load ? ...
Full details

What is the difference between Informatica

What is the difference between Informatica 7.1 and Abinitio ? ...
Full details

How to enter same record twice

How to enter same record twice in the target table ? ...
Full details

What are the designer tools for creating

What are the designer tools for creating transformations ? ...
Full details

What are the Differences between static cache

What are the Differences between static cache and dynamic cache ? ...
Full details

Which kind of index is preferred

Which kind of index is preferred in DWH ? ...
Full details

What are the data movement modes

What are the data movement modes in Informatica ? ...
Full details

What is the default join that source qualifier

What is the default join that source qualifier provides ...
Full details

What are the active and passive

What are the active and passive transformations ? ...
Full details

What are Target Options on the Servers

What are Target Options on the Servers ? ...
Full details

How is Data Models Used in Practice

How is Data Models Used in Practice ? ...
Full details

What is aggregate cache in aggregator

What is aggregate cache in aggregator transformation ? ...
Full details

What is the difference between OLTP& ODS

What is the difference between OLTP and ODS ? ...
Full details

What are the methods for creating

What are the methods for creating reusable transformations ? ...
Full details

What is difference between Mapplet

What is difference between Mapplet and reusable transformation ? ...
Full details

How can you recover the session in sequential

How can you recover the session in sequential batches ? ...
Full details

What are the Advantages of de normalized data

What are the Advantages of de normalized data ? ...
Full details

Why to use stored procedure

Why to use stored procedure in ETL Application ? ...
Full details

What is difference between maplet

What is difference between maplet and reusable transformation ? ...
Full details

What are parallel queries

What are parallel queries and query hints ? ...
Full details

Why use the lookup transformation

Why use the lookup transformation ? ...
Full details

What are the different threads in DTM process

What are the different threads in DTM process ?...
Full details

What is difference between a connected

What is difference between a connected look up and unconnected...
Full details

What are the transformations that restrict

What are the transformations that restrict the partitioning of sessions ? ...
Full details

What is the default source option

What is the default source option for update strategy transformation ? ...
Full details

What are the mapping parameters

What are the mapping parameters and mapping variables ? ...
Full details

What is source qualifier ?

What is source qualifier ? ...
Full details

What is query panel ?

What is query panel ? ...
Full details

What are the scheduling options

What are the scheduling options to run a session ? ...
Full details

What are the session parameters

What are the session parameters ? ...
Full details

What are the types of lookup

What are the types of lookup ? ...
Full details

What is surrogate key

What is surrogate key ? ...
Full details

What is confirmed dimension and fact

What is confirmed dimension and fact ? ...
Full details

What is Code Page Compatibility

What is Code Page Compatibility ? ...
Full details

What is the difference between Power Centre

What is the difference between Power Centre and Power Mart ? ...
Full details

Why do we use DSS database for OLAP tools

Why do we use DSS database for OLAP tools ? ...
Full details

What is Meta data and system catalog ?

What is Meta data and system catalog ? ...
Full details

What is active and passive transformation

What is active and passive transformation ? ...
Full details

How to recover the standalone session

How to recover the standalone session ? ...
Full details

What is operational data source

What is operational data source (ODS) ? ...
Full details

What is Cognos script editor ?

What is Cognos script editor ? ...
Full details

What is the approximate size of data warehouse ?

What is the approximate size of data warehouse ? ...
Full details

What is difference between COM & DCOM ?

What is difference between COM & DCOM ? ...
Full details

What is the use of incremental aggregation ?

What is the use of incremental aggregation ? ...
Full details

What is the procedure to load

What is the procedure to load the fact table ? ...
Full details

Explain about perform recovery ?

Explain about perform recovery ? ...
Full details

What is the use of Micro Strategy ?

What is the use of Micro Strategy ? ...
Full details

What is the Difference between DSS & OLTP ?

What is the Difference between DSS & OLTP ? ...
Full details

What is meant by lookup caches ?

What is meant by lookup caches ? ...
Full details

What is the Rank index in Rank transformation ?

What is the Rank index in Rank transformation ? ...
Full details

Why we use partitioning the session in Informatica ?

Why we use partitioning the session in Informatica ? ...
Full details

What is power center repository ?

What is power center repository ? ...
Full details

Where we can use Partition ?

Where we can use Partition ? ...
Full details

How to import oracle sequence

How to import oracle sequence into Informatica ? ...
Full details

What are the types of metadata

What are the types of metadata that stores in repository ? ...
Full details

Explain the flow of data in Informatica ?

Explain the flow of data in Informatica ? ...
Full details

What are the reusable transformations

What are the reusable transformations ? ...
Full details

What is the Router transformation ?

What is the Router transformation ? ...
Full details

When the Informatica server marks

When the Informatica server marks that a batch is failed ? ...
Full details

What is Performance tuning in Informatica ?

What is Performance tuning in Informatica ? ...
Full details

How can you complete unrecoverable sessions ?

How can you complete unrecoverable sessions ? ...
Full details

What are the types of mapping wizards

What are the types of mapping wizards that r to be provided in Informatica ? ...
Full details

What is incremental aggregation ?

What is incremental aggregation ? ...
Full details

What is power play plug in ?

What is power play plug in ? ...
Full details

What are the join types in joiner transformation ?

What are the join types in joiner transformation ? ...
Full details

What is status code ?

What is status code ? ...
Full details

What are Dimensions and various types

What are Dimensions and various types of Dimensions ? ...
Full details

Why dimension tables are denormalized in nature ?

Why dimension tables are denormalized in nature ? ...
Full details

Where is the cache stored in Informatica ?

Where is the cache stored in Informatica ? ...
Full details

Why you use repository connectivity ?

Why you use repository connectivity ? ...
Full details

What is hash partition ?

What is hash partition ? ...
Full details

What is an MDDB ?

What is an MDDB ? ...
Full details

What is the architecture of Data warehousing

What is the architecture of Data warehousing project ? ...
Full details

What is a look up function ?

What is a look up function ? ...
Full details

What are limitations of joiner transformation ?

What are limitations of joiner transformation ? ...
Full details

What is fact less fact schema ?

What is fact less fact schema ? ...
Full details

Why we use lookup transformations ?

Why we use lookup transformations ? ...
Full details

Can we generate reports in Informatica ?

Can we generate reports in Informatica ? ...
Full details

What is DTM process ?

What is DTM process ? ...
Full details

What is IQD file ?

What is IQD file ? ...
Full details
Log in
Popular tags