what are the limitations for bulk loading in informatica for
all kind of databases and transformations?

Answers were Sorted based on User's Feedback



what are the limitations for bulk loading in informatica for all kind of databases and transformat..

Answer / sujana

v need to disable constraints while performing bulk loading

Is This Answer Correct ?    12 Yes 0 No

what are the limitations for bulk loading in informatica for all kind of databases and transformat..

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

what are the limitations for bulk loading in informatica for all kind of databases and transformat..

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

Post New Answer

More Informatica Interview Questions

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  


error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,


what is target update override and when we use it?

2 Answers   TCS,


What is the difference between a table and the materialized view?

2 Answers  


How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,


Which is costliest transformation? costly means occupying more memory?

3 Answers  


how can we use sorter transformation in joins?

5 Answers   IBM,


how can we load starting with 11th record of a table from source to target

6 Answers   IBM,


can we generate reports in informatica ? How?

3 Answers  


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

7 Answers   Deloitte,


Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,


Categories