what are the limitations for bulk loading in informatica for
all kind of databases and transformations?
Answer Posted / 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 |
Post New Answer View All Answers
How many input parameters can exist in an unconnected lookup?
What are the different versions of informatica?
How to do the error handling of if ur source is flatfiles?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are connected or unconnected transformations?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Please let me know how to make Data masking in informatica..
How to load last n records of file into target table - informatica
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Enlist the tasks for which source qualifier transformation is used.
On which transformations you created partitions in your project?
What are the performance considerations when working with aggregator transformation?
Where are the source flat files kept before running the session?