Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

Zensar,

2 7201

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

Emphasis,

6 10213

Can anyone please distinguish what is Inner join and Outer join

Wipro,

2 6431

What is the exact difference b/w IN and EXIST in Oracle..?

Wipro,

4 9441

i have two source data there is no pk,fk how to join the two sources

TetraSoft,

5 11637

diffrence between command task and control task

iNautix,

1 7398

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

Wipro,

3 7245

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

TCS,

4 10826

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

HCL,

2256

is it possible to index the data in cache of lkp transformation ?

 2082

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

 3 7387

how can import the data from the flat files?

 2 6058

major difference between normal loading and bulk loading?

 6 12619

explain about session partitions ?

 1 5952

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

TCS,

5 8815

Un-Answered Questions { Data Warehouse }

What is Online View?

2015

Explain the term 'tables' related to relational database management system?

1109

What is the need of an ETL tool?

1166

What is metadata in context of a datawarehouse?

1141

How to load specific no.of records using bteq, or fastload,or multiload

1820

What is spool space?

1233

How do you connect the desktop application to metadata server? : sas-grid-administration

1147

How to add default rules in the transformer?

1291

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2305

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

1059

How can one find bugs in job sequence?

1504

Mention what is a partition and what are the different types of partition components in abinitio?

1243

Explain what is metadata reporter?

1032

Can you state some of the innovations throughout history?

1050

How to do unit testing in informatica? How to load data in informatica ?

1199

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