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

what is the difference between breaks and sections?

IBM,

3 8560

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

DELL, iGate,

2 9297

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3756

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

IBM,

1 5337

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2107

how to generate means for every subject;

Mind Tree,

4 8031

how to change the execute of macro

Mind Tree,

2315

how to generate report for 0 observation dataset?

Mind Tree, Student,

3 7035

"What is the difference between proc sort nodup and proc sort nodupkey?"

2 7042

What are the types(Specific Names) of Scheduling in BO?

Cap Gemini,

3 10694

What is Array bind size in universe? Plz

TCS,

2 19128

What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.

Collabera,

3 7996

what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

TCS,

1 7227

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

TCS,

3 8228

what is the difference between informat$8. $char8.

SAS,

3 12948


Un-Answered Questions { Data Warehouse }

What is the roundrobin collector?

1099


What are the main components of teradata system?

1135


Define APT_CONFIG in Datastage?

1080


What is Session and Batches?

1108


Design a mapping to load the cumulative sum of salaries of employees into target table?

1505


how the sas basic syntax style described? : Sas-administrator

1019


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1910


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10893


How can we use mapping variables in informatica? Where do we use them?

1201


Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

2110


What is the difference between formal and export parameter? Export at what secenario we are going to use?

2638


What is the multi-insert?

1032


What are the settings that you use to configure the joiner transformation?

1055


What are the types of catalogs in cognos?

1144


Explain batch processing in ab initio?

1456