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

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

how DTM buffer size and buffer block size are related

3 Answers   Wipro,


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  


hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,


Please let me know how to make encryption and decryption with example?

0 Answers  


Why do you use Mapping Parameter and mapping variable?

0 Answers  






what is datamart

4 Answers   IBM, Informatica,


pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,


what r the values tht r passed between informatics server and stored procedure?

1 Answers  


Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,


How to get EVEN & ODD numbers separately?

8 Answers  


How to use procedural logic inside infromatica?

0 Answers  


what is degenerated dimension

6 Answers   Cap Gemini,


Categories