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 7085

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 9977

Can anyone please distinguish what is Inner join and Outer join

Wipro,

2 6300

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

Wipro,

4 9295

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

TetraSoft,

5 11439

diffrence between command task and control task

iNautix,

1 7322

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 7097

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

TCS,

4 10635

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,

2189

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

 2033

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 7265

how can import the data from the flat files?

 2 5950

major difference between normal loading and bulk loading?

 6 12419

explain about session partitions ?

 1 5846

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 8657

Un-Answered Questions { Data Warehouse }

Explain the meaning of Amp?

1162

In general, how do you optimze any sql in teradata?

1048

how to debug and test the sas program? : Sas-administrator

1045

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2064

what is sas olap server? : Sas-di

1265

Define slowly changing dimensions (SCD)?

1062

What is meant by lookup transformation? Explain the types of lookup transformation?

956

What is PDV?

1162

What is the difference between nodupkey and nodup options?

1049

Enlist the various types of transformations.

1067

------------ Diff b/w MemberCaption and MemberDescription?

2324

During the running session, output files are created by informatica server. Enlist few of them.

991

ware house management system is used?

1022

What do you understand by the term ‘transformation’?

1049

what is session partitioning?

2150

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