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

what is the function in Transformer stage can act as Rank function in Oracle

Reliance,

1 14632

how can we send even and odd records from a sequential file to two different targets

IBM, iGate, TCS,

10 35187

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

Reliance,

1 5879

why we use parameters instead of hard code in datastage

HCL,

4 13593

which memory is used by lookup and join

IBM,

5 13109

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

Accenture, Cognizant,

5 16906

what is dynamic cashe

Informatica,

3 7049

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

Target,

4 23804

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

Cap Gemini, IBM,

10 20388

give me scenario on cascading prompts&master-detail relation

IBM,

4 18291

if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??

Accenture,

6 11716

is it possible to generate sas datasets using proc print ???

GSK GlaxoSmithKline,

1 6956

what are all the ways to define macro variable??

GSK GlaxoSmithKline,

2 7351

what are all the default values getting in PROC MEANS...???

 2 6257

What type of tables you are using in YOUR reporting..???

GSK GlaxoSmithKline,

2 6444

Un-Answered Questions { Data Warehouse }

How can we use mapping variables in informatica?

1131

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1052

What is a data profile?

1037

What is the function of surrogate key in data warehousing?

1145

how can we analyze the locks ?

2198

describe about metadata object? : Sas-di

1137

Write the components microstrategy metadata?

1070

How can you define user defied event?

1081

What do you understand by the term Normal Distribution?

1045

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1917

What is defined as partial backup?

1134

Can you filter data in hashed file?

3834

How to startup obiee in linux?

939

Explain why double trailing @@ is used in input statement?

1116

What is the difference between order and group variable in proc report?

1493

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