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 u insert o ne row in the target if that row does not exists in the target and update if it exists

Accenture,

6 15157

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

TCS,

6 12066

what is the diff b/w cached and unchaed look ups

IBM, TCS, Wipro,

3 8063

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 9405

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 5634

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

Syntel,

2 12940

How to remove duplicates in transformer stage? in parallel mode

Syntel, TCS,

6 17739

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

Syntel,

4 15583

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 11252

how to delete one row in target dataset

Satyam,

1 3180

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

IBM,

8 29815

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

IBM,

1 6385

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3441

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

Emirates, IBM,

10 15714

is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)

2 7376


Un-Answered Questions { Data Warehouse }

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

2059


explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4191


Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2261


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1237


Demonstrate experience in maintaining quality process standards?

2669


faq's on cognos

4112


i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2765


What are the data types present in bo? What happens if we implement view in the designer and report?

1082


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

1079


How do you remove duplicate records in informatica? And how many ways are there to do it?

1231


What is dimensional table?

1159


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167


What is node? How many nodes and amps used in your previous project?

1173


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2792


can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2332