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 is the default join that source qualifier provides?
in performance wise union is past,union all is past
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is sequence generator transformation in informatica?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
What is a transaction control transformation?
what are challenges that you faced in testing? give solution to it?
Explain joiner transformation in informatica
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?