what are the limitations for bulk loading in informatica for
all kind of databases and transformations?
- 3 Answers
- 14400 Views
- Accenture, CSC, I also Faced
- E-Mail Answers
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 |
In real time scenario where can we use mapping parameters and variables?
What is a unit Testing?
what is row level and column level indicator?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
Can we run session without using workflows?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
What is a node in Informatica?
Teradata 
