How to enter same record twice in the target table,explain?
Answer Posted / saradhi
i think its happen only if the target table does not have
any primary key.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is enterprise data warehousing?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How many ways a relational source definition can be updated and what are they?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the use of transformation?
What are the types of caches in lookup?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is rank index in rank transformation?
How do you migrate data from one environment to another?
How to improve the performance of a session using sorter transformation?
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 size of u r database?