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 |
How do you manage the Parameter files while migrating your data from one environment to another environment?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
what is target update override and when we use it?
What is the difference between a table and the materialized view?
How to Join Tables my Source is having 15 table target is one?
Which is costliest transformation? costly means occupying more memory?
how can we use sorter transformation in joins?
how can we load starting with 11th record of a table from source to target
can we generate reports in informatica ? How?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
Can we write to_date(three arguments) ? Will it work ? Advance thanks