While using update strategy in the mapping which gives more performance, a fla

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

4 Answers
9065 Views
I also Faced
E-Mail Answers

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

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers IBM,

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers HP,

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers iGate,

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers

What is the function of union transformation?

0 Answers

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers Informatica,

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers IBM,

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers

how to move the mappings from your local machine to claint place?

2 Answers

What are Dimensional table?

0 Answers Informatica,

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers IBM,

can you avoid static cache in the lookup transformation? I mean can you

1 Answers

For more Informatica Interview Questions Click Here