1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

Hi
I'm using data federator.I would like to know if it allows
select statment in where clause.For example:
SELECT Employee, company, orgunit
FROM TAB_BIG
WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL
WHERE flag = X )
bye

Question Posted / enzodm

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Business Objects Interview Questions

What are the types of errors you faced while creating a report from two different data providers

3 Answers   IBM,

HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?

1 Answers  

Explain what is the difference between slice and dice and cross tab report?

0 Answers  

Explain the data types present in bo and what happens if we implement view in the designer and report?

0 Answers  

I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record

0 Answers   Flextronics,




Please Send to my e-mail Interview Questions With Answers , Technical Test Questions With Answers and Code Snippets Of Business Objects - Dev , Business Objects - Reporting Analysis .

3 Answers   AOL,

9.what are the multidimensional analyses

4 Answers   TCS,

User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.

1 Answers  

how to overcome overflow of data in a report

6 Answers  

Explain when to use local filter and when to use global filter?

0 Answers  

how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?

3 Answers   TCS,

Pls Explain about the different between 6.5 & Xi R2

2 Answers   IBM,

For more Business Objects Interview Questions Click Here
Categories