In update strategy target table or flat file which gives
more performance ? why?

Answer Posted / nagaraju

flat file is better than relational becoz there is no index concet in flat file

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to do unit testing in informatica?

726


What are the components of the workflow manager?

642


Make a note of the quantity vaults made in informatica?

561


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9169


What is transformation?

663






Can we create multiple integration service on single repository?

705


Explain informatica architecture - version 8 / 9

674


What all are steps in up gradation of Informatica server?

624


How do you remove duplicate records in informatica? And how many ways are there to do it?

717


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1418


Is there any way to read the ms excel datas directly into informatica?

552


Explain how to import oracle sequence into informatica?

594


Name the different lookup cache(s)?

712


tell me about your project functionality

1870


Explain transaction control transformation in informatica

763