While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?

Answer Posted / sanjay

You are write Krish.. we can not use update stratety in flat
files...

Can I have ur mail id plz?.. my email id is
sanjaygupta1981@gmail.com

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1459


Can we create a node as a gateway node and the same node can be assigned to a grid?

635


Partition, what happens if the specified key range is shorter and longer

2027


What is union transformation?

568


What is the function of aggregator transformation?

573






Explain joiner transformation in informatica

664


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1501


What is a pre-defined event and user-defined event?

574


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1247


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1511


What is informatica worklet?

608


Can informatica load heterogeneous targets from heterogeneous sources?

690


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1744


Explain the code page compatibility?

636


Which are the different editions of informatica powercenter that are available?

553