1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

Difference between Data and Index Caches?

Informatica,

660

How many ways are there to create ports?

Informatica,

731

Which means the first record should come as last record and last record should come as first record and load into the target file?

Informatica,

610

What is blocking transformation?

Informatica,

722

Explain the tuning lookup transformation - informatica

Informatica,

615

Explain about Informatica server process that how it works relates to mapping variables?

Informatica,

624

What are the settings that you use to configure the joiner transformation?

Informatica,

613

How to load the data from a flat file into the target where the source flat file name changes daily?

Informatica,

577

Explain target update override in informatica

Informatica,

631

how to create user defined function (udf) in informatica

Informatica,

785

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

Informatica,

787

What is the difference between stop and abort in informatica

Informatica,

664

Explain constraint based loading in informatica

Informatica,

661

As union transformation gives UNION ALL output, how you will get the UNION output?

Informatica,

647

What are active and passive transformations?

Informatica,

654

Un-Answered Questions { Data Warehouse }

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

794

List the logical and conditional operators that are used with teradata along with their meanings?

554

how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

1309

What are algorithms provided by Microsoft in SQL Server?

1574

What is logical data model?

644




What is fact degradation?

568

What are the features of ab initio?

627

what is metadata? : Sas-bi

600

Mention what is the difference between nodupkey and nodup options?

595

What is fact table? Explain the different kinds of facts.

616

What is the functional & architectural differences between business objects and web intelligence reports?

561

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

526

How transaction file different from that of a sort file?

891

What are orabulk and bcp stages?

649

What are the newly developed features of Teradata?

573

For More Un-Answered { Data Warehouse } Questions Click Here