Interested to Buy Any Domain ? << Click Here >> for more details...
what are the limitations for bulk loading in informatica for
all kind of databases and transformations?
- 3 Answers
- 15223 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 |
Clarify the utilization of aggregator cache record?
HOW TO GET THE LATEST DATA IN SCD ?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
What is informatica powercenter repository?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
Repository user profiles
what is degenerated dimension
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
Teradata 
