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...



Data Warehouse Interview Questions
Questions Answers Views Company eMail

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

IBM,

9844

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 2942

when informatica 8 series released ?

IBM,

1 4233

what is meant by data driven.. in which scenario we use that..?

IBM,

2 6596

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1944

wt r before journal& after journel.....in teradata

4 9693

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 5213

what is the use of Data Mart?

IBM,

5 7988

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

iGate, Qualcomm,

2 7928

performance tuning of Informatica

1 5337

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

Informatica,

5 9264

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

Sapient,

2 6516

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

IBM,

3 8075

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

L&T,

2568

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

Polaris,

5 9238


Un-Answered Questions { Data Warehouse }

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2077


Can the administrator easily maintain and manage microstrategy intelligence server?

1036


How co> operating system natively processes the data?

1111


What are the different forms of output that can be obtained after processing of data?

1266


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2136


how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.

880


Explain difference between powerplay transformer and power play reports?

968


Briefly state different between data ware house & data mart?

1065


what is document design in boxi,have u participate in that

2205


Explain me what are data marts?

1065


how will you locate the sas platform applications? : Sas-bi

1046


What differs when we choose the sorted input for aggregator transformation?

1038


What are the transformations that are not supported in mapplet?

1045


What is the use of stop statement?

1095


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2263