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

scenario

1 4051

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

Amdocs,

1 4529

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

TCS,

3 8108

How can we select pr retrieve the particular row in dataset by using orchadmin command?

IBM,

1 4198

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

CGI,

1 5446

Hi Cognos Folks, I have all cognos certification dumps. In fact i am certified in most of the dumps recently. I have cognos material, pdfs, user guides, documents along with dumps. If any one required cognos dumps, please drop me mail at cognos.biuser@gmail.com Thanks, Cognos bi user

IBM,

13 18849

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1941

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

Thomson Reuters,

1 5333

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

Thomson Reuters,

3 13337

can we import source table without using source qualifier? if yes then how? if no then why?

Thomson Reuters,

2 10549

in my source table i want to delete first and last records and load in between records into target? how can it possible?

HCL, Thomson Reuters,

3 9820

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

Thomson Reuters,

6 11656

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

Thomson Reuters,

2 6842

Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.

2 5126

How many number of reject links merge stage can have?

TCS,

7 14922


Un-Answered Questions { Data Warehouse }

Describe primary index in teradata. And what are the available primary index types?

940


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

1010


What do you mean by static prompt report?

936


Explain what is data step?

1132


Explain a linked cube?

907


What are the prime responsibilities of data integration administrator? : Sas-di

1004


What is pre-emptive and non-pre-emptive?

913


: and & modifiers.

1336


State the differences between shortcut and reusable transformation

987


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

2772


Why and when do you use proc sql?

1185


What sort of existing documents should business analysts refer to when starting on a new project?

966


Explain what is fact less fact table? Where you have used it in your project?

870


What is the advantage of informatica?

1016


Now, imagine this, you come across a situation where an aggregate table at higher level has a higher lts than the one at lower level. A.) What problems can you anticipate? B.) How would you solve the problem.

957