Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / naga

Flat file is better only for Insert,but if you are using
Update strategy for updating a table then table gives
better performance and FYI a Flatfile cannot be updated

Is This Answer Correct ?    9 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1947


How are indexes created after completing the load process?

1722


What is the cumulative sum and moving sum?

1235


How to create Target definition for flat files?

1284


How to load last n records of file into target table - informatica

1134


How can we handle two sessions in informatica?

1094


what are the deliverables?in your project?

2196


Explain what transformation and how many are there in informatica?

1029


What is rank transform?

1061


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1081


Explain why we use partitioning the session in informatica?

1164


What is rank index in rank transformation?

1130


What is a repository? And how to add it in an informatica client?

1195


If informatica has its scheduler why using third party scheduler?

1310


How do you convert single row from source into three rows into target?

1216