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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is lookup table in etl testing?

 730

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

 762

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

 655

What is the maximum and minimum length of macro variable

 648

Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

 641

Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump

 1 2905

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

 759

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

 560

What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

 856

How can we increase the loading performance of oracle table in AbInitio?

 630

What happens when we provide null key to sort, merge and pbks in Abinitio ?

 811

Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

 848

Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

 967

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

 542

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

 551

Un-Answered Questions { Data Warehouse }

What do you mean by ttu in teradata?

563

Explain what are the advantages of query studio compared to report studio?

538

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1548

Why and when do you use proc sql?

749

Your i-sever crashed. What will you do?

641




what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1772

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

626

Mention how to limit decimal places for the variable using proc means?

633

What are the features of SAS?

569

what is the difference steps for data modeling?

2070

What are the newly developed features of Teradata?

567

Compare dataset and fileset?

559

What is an expression transformation?

586

i have one file i saved in csv how can i take these file into framework manager

1530

Explain how many universes can be created in a project?

607

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