Sign Up Login


  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

Define enterprise data warehousing?

0 Answers  

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  

Why we require dwh in particular projects?

1 Answers   Amdocs,

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,

What are the ETL tools available in DWH?

6 Answers   Mphasis,

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

what is incremental data aggregation?

3 Answers   IBM,

What are the new features of informatica 9.x at the developer level?

0 Answers  

For more Informatica Interview Questions Click Here
Categories