saritha

• Mar 1st, 2006

Partition points mark the thread boundaries in a source pipeline and dividethe pipeline into stages.

Answer Question  Select Best Answer

Gayathri

• Mar 2nd, 2006

Cost based and rule based approaches are the optimization techniques which are used in related to databases, where we need to optimize a sql query. Basically Oracle provides Two types of Optimizers (i...

Answer Question  Select Best Answer

kundan

• Mar 11th, 2006

Micro strategy is again an BI tool whicl is a HOLAP... u can create 2 dimensional report and also cubes in here.......basically a reporting tool. IT HAS A FULL RANGE OF REPORTING ON WEB ALSO IN WINDOWS.

Answer Question  Select Best Answer

Sanyam Mittal

 Profile Answers by Sanyam Mittal Questions by Sanyam Mittal

• Feb 26th, 2006

First of all meet your sponsors and make a BRD(business requirement document) about their expectation from this datawarehouse(main aim comes from them).For example they need :customer billing process....

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

ya shoor,Just right click on the particular session and going to recovery optionorby using event wait and event rise

Answer Question  Select Best Answer

Reddy

• Mar 6th, 2006

ya Its Posible using pmcmd Command with out using the workflow Manager run the group of session.as per my knowledge i give the answer.

Answer Question  Select Best Answer

Can any one please tell me how to explain Data warehouse project in interview and from where to start and end. what to explain completely in it(data warehouse project), how much hast to explain from it(dw project) and what is architecture of it and data flow and construction of dw project or data warehouse.

what is data warehouse methodology ,types of dw methodology, most using dw methodology...

shilpa

• Jul 20th, 2011

Hi , when interviewer asks this question , it means he/she is asking about your current project work/task requirement. So u may tell from requirement gathering to the report generation. or u may proba...

Answer Question  Select Best Answer

suresh

• Mar 17th, 2006

You should configure the mapping with the least number of transformations and expressions to do the most amount of work possible. You should minimize the amount of data moved by deleting unnecessary l...

Answer Question  Select Best Answer

balaji

• Oct 5th, 2006

Hai,COM is technology developed by Microsoft  which is based on  OO Design .COM Componenets exposes its interfaces  at  interface pointer  where client access Components ...

Answer Question  Select Best Answer

sm1506

• Apr 7th, 2006

Most complex logic we use is denormalization. We dont have any Denormalizer transformation in INformatica. So we will have to use an aggregator followed by an expression. Apart from this, we use most ...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: sm1506

• Apr 7th, 2006

---

Rank:
1
2<--2nd position
2<--3rd position
4
5

Same Rank is assigned to same totals/numbers. Rank is followed by the Position. Golf game ususally Ranks this way. This is usually a Gold Ranking.

Dense Rank:
1
2<--2nd position
2<--3rd position
3
4

Same ranks are assigned to same totals/numbers/names. the next rank follows the serial number.

sm1506

• Apr 7th, 2006

Rank:12<--2nd position2<--3rd position45Same Rank is assigned to same totals/numbers. Rank is followed by the Position. Golf game ususally Ranks this way. This is usually a Gold Ranking.Dense Ra...

Improve Answer

Prasad

• Jul 14th, 2006

Hi,1> Native connection is something which is provided by the same vendor for that tool. eg: oracle warehouse builder has its own driver to connect to oracle DB which does not use a ODBC driver. here ...

Answer Question  Select Best Answer

You can download an IBM Book on Dimensional Modeling from the following link:http://www.redbooks.ibm.com/abstracts/sg247138.html?OpenThis is an excellent IBM Redbook on Data warehouse design and Dimensional Modeling design.Great to read,Dave

sithu

 Profile Answers by sithu Questions by sithu

• May 26th, 2006

Guys,http://freedatawarehouse.com/tutorials/default.aspxCheers,Sithusithusithu@hotmil.com

Answer Question  Select Best Answer

srinivas vadlakonda

• Sep 28th, 2006

By using Custom transformation we create the single input ports and mulple output ports or mulple input ports and single inport otherwise mulple input or output ports. when we cliking the custom trans...

Answer Question  Select Best Answer

It displays update information about the session in the monitor window.

kalyan

• May 1st, 2006

It displays the updated information about the session in the monitor window. The monitor window displays the status of each session when you poll the Informatica server.

Answer Question  Select Best Answer

sunil_reddy

 Profile Answers by sunil_reddy Questions by sunil_reddy

• Apr 14th, 2006

It only creates a copy of it..

Answer Question  Select Best Answer

MOOTATI RAGHAVENDROA REDDY

• May 8th, 2006

Yes, we can stop the batches using server manager or pmcmd commnad

Answer Question  Select Best Answer

Cholleti Kiran Kumar

• Apr 28th, 2006

            For example u have a table Emp_Name and it has two columns Fname, Lname in the source table which has douplicate rows. In the mapping Crea...

Answer Question  Select Best Answer

Uma Bojja

 Profile Answers by Uma Bojja Questions by Uma Bojja

• May 3rd, 2006

When the repo is up and the PMSERVER is also up, workflow monitor always will be connected on-line.When PMserver is down and the repo is still up we will be prompted for an off-line connection with which we can just monitor the workflows previously ran.

Answer Question  Select Best Answer

starg

• Apr 20th, 2006

In informatica there is no method for unit testing. There are two methods to test the mapping.1. But we have data sampling. set the ata sampling properties for session in workflow manager for specifie...

Answer Question  Select Best Answer