what are the limitations for bulk loading in informatica for
all kind of databases and transformations?
Answers were Sorted based on User's Feedback
Answer / sujana
v need to disable constraints while performing bulk loading
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / sunil
Bulk load is used for external loaders and in bulk load we
will not write information to datalog file so if any
recovery is needed it is not possible
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / vikas
1.update strategy
2.no constraints on target
3.target should be relational database
4.less number of records
| Is This Answer Correct ? | 2 Yes | 0 No |
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
Tell me one complex query in oracle ?
What are the new features of informatica 7.1?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
How can we use mapping variables in informatica? Where do we use them?
what is song in infrmatica...?
What is degenerated dimention table?
What are limitations of joiner transformation?
Write the different tools in the workflow manager?
What is the difference between a shortcut of an object and copy of an object? Compare them.
what is degenerated dimension