Data Warehouse Interview Questions
Questions Answers Views Company eMail

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

998

What are the differences between oltp and olap?

527

What are the types of schemas we have in data warehouse and what are the difference between them?

503

Differentiate between reusable transformation and mapplet.

543

Why update strategy and union transformations are active?

562

What is meant by target load plan?

536

How to join three sources using joiner?

547

How do you update the records with or without using update strategy?

634

What are the differences between source qualifier and joiner transformation?

573

How do you convert single row from source into three rows into target?

579

What are the types of schemas we have in data warehouse.

508

Why update strategy and union transformations are active? Explain with examples.

682

How do you remove duplicate records in informatica?

1 672

How do you load alternate records into different tables through mapping flow?

1264

How do you load first and last records into target table?

641


Un-Answered Questions { Data Warehouse }

What are the various kinds of containers available in datastage?

542


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

324


What are the steps to do to use alerts in bo?

611


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2249


What are roles and groups and benefits of using them?

543






What is PDV?

701


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

548


EXPLAIN SCD

932


Explain lookup transformation is active in informatica

634


write a query to display the departments with no employee?

1531


What are the job parameters?

680


Mention a few of the ETL tools that come under Teradata.

593


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

644


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

678


what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

1891