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 |
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
scenario
what is mystery dimension?
What are the reusable transforamtions?
What are the different options available for update strategy?
enterprise datawarehouse your project phase by phase explain?
what is fact table?
Tell me about MD5 functions in informatica
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Scheduling properties,whats the default (sequential)