1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / sujith

Answers were Sorted based on User's Feedback



While using update strategy in the mapping which gives more performance, a flat file or Table? Why..

Answer / kish`

hi,

update strategy never use for flatfiles....plz correct me,
if it is wrong

Is This Answer Correct ?    14 Yes 1 No

While using update strategy in the mapping which gives more performance, a flat file or Table? Why..

Answer / krish

yes ur rt man
hay kish can i have ur mail id

Is This Answer Correct ?    0 Yes 0 No

While using update strategy in the mapping which gives more performance, a flat file or Table? Why..

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

While using update strategy in the mapping which gives more performance, a flat file or Table? Why..

Answer / krish

flat file
bcz no connections needed no network busy etc;

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Informatica Interview Questions

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  

which one is better either active or passive transformation in informatica

1 Answers  

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

How we can use union transformation?

0 Answers  




Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

Explain factlessfact table with scenario

1 Answers   HCL,

What is the need for an etl tool?

0 Answers  

How to add source flat file header into target file?

3 Answers   Logica CMG,

What is the difference between view and materialised view?

6 Answers  

For more Informatica Interview Questions Click Here
Categories