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
Answer / kish`
hi,
update strategy never use for flatfiles....plz correct me,
if it is wrong
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / krish
flat file
bcz no connections needed no network busy etc;
| Is This Answer Correct ? | 0 Yes | 5 No |
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
When we are using Dynamic Cache,which options we will select in session level?
hw cn v elimate dublicate values from lookup without overriding sql?
without dynamic lookup transformation how to insert new rows and update existing rows?
Can we update the data in flat file using update strategy?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
Diff b/w ShortCut and reusabel Object ?
What is the maplet?
What is different between informatica version 8 and 9 version
Differentiate between source qualifier and filter transformation?