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 7095

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 9995

Can anyone please distinguish what is Inner join and Outer join

Wipro,

2 6314

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

Wipro,

4 9308

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

TetraSoft,

5 11453

diffrence between command task and control task

iNautix,

1 7327

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 7108

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

TCS,

4 10657

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,

2199

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

 2040

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 7272

how can import the data from the flat files?

 2 5955

major difference between normal loading and bulk loading?

 6 12425

explain about session partitions ?

 1 5854

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 8672

Un-Answered Questions { Data Warehouse }

What are the prerequisite tasks to achieve the session partition?

1268

What is the profile and package?

2309

To what type of programms have you used scratch macros?

2578

What do you understand by the term 'aggregate cache'?

992

How to create a repository in abinitio for stand-alone system(local nt)?

1140

What is the function of union transformation?

1150

Where do we use ACvisitor class?

2528

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4172

What are the different types of join operations?

1013

Explain what are the advantages and disadvantages of reporting directly against the database?

1016

What is spool space? Why do you get spool space errors?

1035

What is fact degradation?

983

What are types of transport files?

8023

how do u extract data from different data sources explain with an example?

2263

Explain how spool space is used.

1087

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