Archives of the TeradataForum

Message Posted: Fri, 07 Apr 2006 @ 09:52:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello,

We use informatica external multi loader utility to load into our warehouse and select the Upsert option , around 10 millions will be updates and 4 million will be inserts. I want to know if this is an efficient way of doing it, I think delete and insert will give better performnace than update and insert . Am I correct ?

Also informatica script generates the file layout as shown below , there are a lot of NULLIF which are very resource intensive,is there a way to overcome this ? What does a '*' indicate here?

     .Layout InputFileLayout;
     .Field  AIR_BOOKABILITY_ID                           1 CHAR(   15)  ;
     .Field  TRAN_DATE                                   16 CHAR(   19)  ;
     .Field  PREV_AIR_BOOKABILITY_ID                     35 CHAR(   15)
     NULLIF PREV_AIR_BOOKABILITY_ID                  = '*' ;
     .Field  TRAN_TYPE                                   50 CHAR(    5)
     NULLIF TRAN_TYPE                                = '*' ;
     .Field  HOST_SYSTEM                                 55 CHAR(    5)  ;
     .Field  CARRIER                                     60 CHAR(    2)  ;
     .Field  MARKET                                      62 CHAR(    6)  ;
     .Field  ADULT                                       68 CHAR(    6)  ;
     .Field  SENIOR                                      74 CHAR(    6)
     NULLIF SENIOR                                   = '*' ;
     .Field  CHILD                                       80 CHAR(    6)  ;
     .Field  YOUTH                                       86 CHAR(    6)  ;
     .Field  INFANT_LAP                                  92 CHAR(    6)  ;
     .Field  INFANT_SEAT                                 98 CHAR(    6)  ;
     .Field  STATUS                                     104 CHAR(    5)
     NULLIF STATUS                                   = '*' ;
     .Field  ORIGINAL_PRICE                             109 CHAR(   10)  ;
     .Field  NEW_PRICE                                  119 CHAR(   10)
     NULLIF NEW_PRICE                                = '*' ;
     .Field  PRICE_RULE                                 129 CHAR(    2)
     NULLIF PRICE_RULE                               = '*' ;
     .Field  SELL_RULE                                  131 CHAR(    2)
     NULLIF SELL_RULE                                = '*' ;
     .Field  FAILOVER_REASON                            133 CHAR(    2)
     NULLIF FAILOVER_REASON                          = '*' ;
     .Field  FAILOVER_TEXT                              135 CHAR(   50)
     NULLIF FAILOVER_TEXT                            = '*' ;
     .Field  EXCEPTION_TEXT                             185 CHAR( 1024)
     NULLIF EXCEPTION_TEXT                           = '*' ;
     .Field  BOOKABILITY_DETAIL                        1209 CHAR( 4000)
     NULLIF BOOKABILITY_DETAIL                       = '*' ;
     .Field  SEARCH_HOST                               5209 CHAR(    5)
     NULLIF SEARCH_HOST                              = '*' ;
     .Field  CLIENT_ID                                 5214 CHAR(  100)
     NULLIF CLIENT_ID                                = '*' ;
     .Field  SEGMENTS                                  5314 CHAR(   12)
     NULLIF SEGMENTS                                 = '*' ;
     .Field  PRICING_ID                                5326 CHAR(   15)
     NULLIF PRICING_ID                               = '*' ;
     .Field  MODIFIED_DATE                             5341 CHAR(   19)
     NULLIF MODIFIED_DATE                            = '*' ;
     .Field  SOURCE_MODIFIED_DATE                      5360 CHAR(   19)
     NULLIF SOURCE_MODIFIED_DATE                     = '*' ;
     .Field  HISTORY_LOAD_DATE                         5379 CHAR(   19)  ;
     .Field  tx_attempt_seq                            5398 CHAR(    6)
     NULLIF tx_attempt_seq                           = '*' ;
     .Field  LAST_TX_ATTEMPT_IND                       5404 CHAR(    6)
     NULLIF LAST_TX_ATTEMPT_IND                      = '*' ;
     .Field  BKB_AGENCY_CODE                           5410 CHAR(    4)
     NULLIF BKB_AGENCY_CODE                          = '*' ;
     .Filler EOL_PAD                                   5414
     CHAR(:CF.PadLength) ;

Thanks!

Naveen.

	<Prev	Next>		<<First	<Prev	Next>	Last>>