Data Warehouse Interview Questions
Questions Answers Views Company eMail

Separate from an archive server and a powerhouse?

480

Make a note of the quantity vaults made in informatica?

541

How is union transformation utilized?

558

What is meant by incremental aggregation?

569

Different qualification between a related rotate toward the sky and isolates look upward?

541

Clarify the aggregator change?

584

What is joiner change?

660

What is lookup change?

610

How might one distinguish in the case of mapping is right or not without associating session?

631

What does cheating measurement mean?

586

Separate from a database, an information bazaar, and an information stockroom?

596

What is depict expression change?

600

What is intricate mapping?

578

Clarify the utilization of aggregator cache record?

566

What does refresh system mean, and what are its distinctive choice?

558


Un-Answered Questions { Data Warehouse }

What is database exceptions in teradata?

534


What is Active Datawarehousing?

550


options available in sequence job to run,validate?

822


Compare cold fusion with other programming languages?

547


Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

1702






What is Fullouterjoin?

1539


Explain how to schedule the report in b.o?

551


How to read the length of word in unix?

871


What is cfapplication tag?

559


What are the features of complex mapping?

630


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

593


Distinguish between cognos dynamic cube and transformer/tm1 cube and powerplay cube?

1


When we should use 'jobid' for commit table (Output table component??

7942


Does redshift support unstructured data?

5


What are the functions of a teradata dba?

587