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 we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

Zensar,

3 7207

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

Emphasis,

6 10224

Can anyone please distinguish what is Inner join and Outer join

Wipro,

2 6434

What is the exact difference b/w IN and EXIST in Oracle..?

Wipro,

4 9446

i have two source data there is no pk,fk how to join the two sources

TetraSoft,

5 11643

diffrence between command task and control task

iNautix,

1 7401

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

Wipro,

3 7249

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

TCS,

4 10828

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

HCL,

1 2257

is it possible to index the data in cache of lkp transformation ?

1 2082

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

4 7388

how can import the data from the flat files?

2 6063

major difference between normal loading and bulk loading?

6 12623

explain about session partitions ?

1 5954

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

TCS,

5 8820


Un-Answered Questions { Data Warehouse }

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2138


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

1076


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2305


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654


Hi, If anyone has base SAS certification dumps, please share.

1932


what are the names of the reports that you prepared?

1185


What is the purpose of Dataware Control?

1110


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1189


draw informatica architecture 8.6 ?

3939


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

4248


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

2759


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1839


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8274


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

4183


How to create the source and target database connections in server manager?

1139