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 |
what are factless facts? And in which scenario will you use such kinds of fact tables.
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
what is the size of u r source(like file or table)?
How do you take care of security using a repository manager
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
What is staging area?
what is the difference between mapplet & stored procedure?
what is surrogate id ?
What is deployment group?
how DTM buffer size and buffer block size are related
Plz..let me know differences between Informatica 7.1 and 8.1?
what is difference between mapping and mapplet ?