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

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

Polaris,

4 7447

Please tell me What is difference between 8.0 and 8.1

IBM,

1 6460

in teradata level primary in table level allows duplicates why?

TCS,

1 6366

in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

IBM,

1 5738

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

TCS,

1 1977

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

TCS,

1 1942

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

TCS,

2 7175

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

TCS,

2 6242

TELL ME ABOUT WORK FLOW SCHEDULING?

TCS,

3 8419

r u done any partitions in ur project?

TCS,

1 1890

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

Polaris,

3 11710

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

Mind Tree, Polaris,

4 9675

can u give example for factless fact table

TCS,

3 6836

how we load the data from source to staging area

TCS,

4 9211

what is syntax of proc merge ?

TCS,

7 17659


Un-Answered Questions { Data Warehouse }

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)

2795


1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

4265


Are you involved in writing the inferential analysis plan? Tables specifications?

4019


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...................................

2334


What is dimensional table?

1167


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..

2771


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2107


Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1044


what is document design in boxi,have u participate in that

2306


Write the unconnected lookup syntax?

1152


What is rollup component?

1337


Explain about a tricky situation for which you found a very simple solution?

1080


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127


what are the names of the reports that you prepared?

1198


how many reports have u created ? explain a few.

2162