Home » Developer & Programmer » Warehouse Builder » infomatica doubts
infomatica doubts [message #93266] Mon, 29 March 2004 20:29 Go to next message
Brijesh
Messages: 8
Registered: January 2002
Junior Member
hi,

   plz clear my doubts,

somebody told me that 1) unique numbers can be generated using expression transformation instead of sequence generator transformation, but how it can be done?

2) using what transformation , the rows can be converted into columns and how.

with regards

Brijesh
Re: infomatica doubts [message #93271 is a reply to message #93266] Tue, 06 April 2004 03:04 Go to previous messageGo to next message
Koteswara Rao
Messages: 1
Registered: April 2004
Junior Member
Hi Brijesh,

For the first one
1) You can create a mapping variable inside a mapping and from within a expression you can increase value of this variable using setcountvariable() expression.

2) This one i am not sure but i heard we can achieve that by using Normaliser transformation. I used the normaliser transformation to populate n rows into target for one particular input row.

Cheers
Koteswara Rao
Re: infomatica doubts [message #93272 is a reply to message #93271] Wed, 07 April 2004 20:52 Go to previous message
Brijesh
Messages: 8
Registered: January 2002
Junior Member
hi koteshwar,
Thanks for that info man,I have another doubt
* in datamarts while is it necessary to maintain the indexes and in what r all the situations it is efficient,because some one asked me if the loading rate is 40 lakh rows per table and overall it may take some 7 hours to create indexes for all the tables with 20 min for each table is indexing efficient ,in such situations .
plz tell me the situations in which we can use indexing and situations not to go for indexing.
Previous Topic: oracle warehouse builder: Please advice Urgent
Next Topic: Looking for opprotunity for Datawarehouse, OLAP, ETL, in US/UK, Australia
Goto Forum:
  


Current Time: Tue Oct 21 14:01:33 CDT 2014

Total time taken to generate the page: 0.61761 seconds