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

how can you load data into target table without leading zeor's

Deloitte,

4 24944

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

TCS,

3 6979

what is the use of layout component reference

Satyam,

3 15982

what is the difference between group span and level span

Satyam,

1 10196

can you please explain me pre session and post session options?

BTBP,

3 7594

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2196

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 6058

How can we integrate different flat file data in a single mapping and with in a single execution

1 4577

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1938

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 7889

what are the default access rights in the teradata?

1 7285

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

TCS,

2 7561

I have a few records just I want to store data in to targets cycling way how?

Polaris,

2383

I have a few records all are same structures data, I want to store data in multiple targets how?

Polaris,

4 8919

How to lode data in sequntional files perform faster?

Polaris,

1 4257


Un-Answered Questions { Data Warehouse }

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2201


What is the use of powerplay web viewer in cognos?

1096


Why managing the data is important?

1025


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8208


What is report as filter in microstrategy?

925


Explain difference between snow flake and star schema.

1064


Enlist the functions performed by sas.

1145


I have two universes created by two difference database can we join them in designer & report level? How

996


how sas deals with business intelligence? : Sas-bi

1067


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2042


What are vaious etl tools in the market?

1016


Explain how to execute the plsql procedure from the report by clicking with mouse?

1062


What are symget and symput? : sas-macro

1328


What is the difference between business requirement document and use case document.

1021


how many users can open or connect to one of the tm1 web application concurrently?

5