what are the limitations for bulk loading in informatica for
all kind of databases and transformations?
- 3 Answers
- 14131 Views
- Accenture, CSC, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the different types of transformation available in informatica.
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.
What is an active transformation?
How to do unit testing in informatica?
What is a connected transformation?
What is native users?
What is a surrogate key?
What is pmcmd command?
What is a joiner transformation and why it is an active one?
What is powercenter on grid?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is a transaction control transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What do think which one is the better joiner or look up?
