Can we update the data in flat file using update strategy?

Answer Posted / kishore

never use UPDATE STRATEGY for flatfiles

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of transformation?

589


how many types of dimensions are available in informatica?

577


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1549


What could be the possible resons of locks by user?

672


What are the features of complex mapping?

658






What you know about transaction control transformation?

570


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

649


How is union transformation utilized?

581


How to elaborate tracing level?

703


How to load the data from a flat file into the target where the source flat file name changes daily?

590


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5006


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

640


How can you validate all mappings in the repository simultaneously?

776


What all join we can perform in LOOKUP transformation?

577


Is it possible to use a client with different version than that of its Informatica server?

659