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 |
expain about the tune parameters?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
what is the purpose of surrogate key and diff between primary key&surrogate key
How will you check the bottle necks in informatica? From where do you start checking?
what r the values tht r passed between informatics server and stored procedure?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
In operator is used in which transformation in informatica 8.6.0
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
wht is cdc?how to use it in creation of mappings?
Explain scd type 3 through mapping.
Explain what transformation and how many are there in informatica?