Interested to Buy Any Domain ? << Click Here >> for more details...
While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?
- 4 Answers
- 9008 Views
- I also Faced
- E-Mail Answers
Answer Posted / kish`
hi,
update strategy never use for flatfiles....plz correct me,
if it is wrong
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
where to store informatica rejected data? How to extract the informatica rejected data?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is dimensional table? Explain the different dimensions.
How can you define user defied event?
Can you use flat files in Mapplets.
What do think which one is the better joiner or look up?
What is meant by target load plan?
What are multi-group transformations?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
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?
How many number of sessions can one group in batches?
difference between repository database and repository service?
What is Index Caches size?
What are active and passive transformations?
