Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



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

Answer / abhinav

I guess the question was wrong as you cannot update a flat file as target.
In a Flat file data can only be inserted not updated.

Is This Answer Correct ?    6 Yes 0 No

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

Answer / naga

Flat file is better only for Insert,but if you are using
Update strategy for updating a table and also we a Flat
file cannot be updated

Is This Answer Correct ?    7 Yes 2 No

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

Answer / 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

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

Answer / sriram

Update strategy can be performed on tables not on Flat files.

Is This Answer Correct ?    1 Yes 0 No

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

Answer / nishtha

Can someone pls give correct answer for this question?

Is This Answer Correct ?    0 Yes 0 No

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

Answer / nagaraju

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

Is This Answer Correct ?    1 Yes 1 No

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

Answer / sanjay

Flate file give better performance bcz Retrival of data
from flat file is fast then relation database

Is This Answer Correct ?    2 Yes 5 No

Post New Answer

More Informatica Interview Questions

how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,


Can you copy the batches?

3 Answers  


How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  


can we use cartesian join in informatica

3 Answers   IBM,


What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  






How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,


What are the data movement modes in informatcia?

3 Answers  


What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,


Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,


how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  


My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,


what is the gap analysis?

1 Answers  


Categories