sir

• Nov 23rd, 2005

Summary filter can be applieid on a group of rows that contain a common value.where as detail filters can be applied on each and every rec of the data base.

Answer Question  Select Best Answer

kalyan

• Dec 20th, 2005

haiThe best way  to find out bottlenecks is writing to flat file and see where the bottle neck is .kalyan

Answer Question  Select Best Answer

Vamshidhar

• Jan 11th, 2006

Hi,it depends upon the informatica version we r using. suppose if we r using informatica 6 it supports only 32 partitions where as informatica 7 supports 64 partitions.

Answer Question  Select Best Answer

reddeppa

• Jan 1st, 2006

By using ODBC connection.if it is relational.if is flat file FTP connection..see we can make sure with connection in the properties of session both sources && targets.

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 1st, 2006

it's  very easyActually oracle 8i not allowed userdefined data typesbut 9i allowsand then blob,clob allow only 9i not 8iand  more over list partinition is there in 9i only

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

Normalizer: It is a transormation mainly using for cobol sources,it's change the rows into coloums and columns into rowsNormalization:To remove the retundancy and inconsitecy

Answer Question  Select Best Answer

gauravkant

 Profile Answers by gauravkant Questions by gauravkant

• Feb 13th, 2006

Hi,For version control in ETL layer using informatica, first of all after doing anything in your designer mode or workflow manager, do the following steps.....1> First save the changes or new imple...

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

simply man,Cleansing:---TO identify and remove the retundacy and inconsistencysampling: just smaple the data throug send the data from source to target

Answer Question  Select Best Answer

suresh maddineni

• May 14th, 2006

3 layersgraph development environmentcooperating systementerprise metadata environment

Answer Question  Select Best Answer

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