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

TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

TCS,

2 7997

what are different analysis datasets you created and what are the new variables created

Sciformix,

2 7559

in a table it has 200 rows the query is select 150 from tablename.whats the output

Cap Gemini,

2 9232

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

Cap Gemini,

2 8414

What are the analysis datasets created, and what are the new variables created in CLINICAL SAS

Accenture, Sciformix,

1 5065

Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

2144

How to save the log information in a file for future use

HCL,

2 9802

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

TCS,

2 7933

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2514

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

Cap Gemini,

3 7932

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

CTS,

2 7508

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

Amdocs,

5 11403

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2270

What are the different types of Fatcs? Explain with example only

CTS,

3 12444

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1902


Un-Answered Questions { Data Warehouse }

List down the reasons for choosing sas over other data analytics tools.

1343


What are different table types used in teradata?

1097


how to load the data to fact table?

2777


Can you explain a cognos controller?

1076


What is data validation strategies for data mart v?

1179


difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2882


What are aggregate tables? How do you design them using teradata?

1221


describe the Steps to confiure a Qlogic switch

2440


How do you add default rules in transformer?

1274


what is sas application server? : Sas-di

1148


Name a few sectors which use data warehousing?

986


What kind of application/services uses Redshift database?

5


Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

2022


Explain the key challenges that you face while performing etl testing.

1059


What are the differences between joiner transformation and source qualifier transformation?

1240