when i was running the seesion, after loading 100 records,
session suddenly fails.Next time i want to load the remaing
rows in target with out truncate target table.What should i
use?
Answer Posted / krishna
gayathri,
if you work in the same manner probably there is a chance
of record duplicates to be loaded if you restart the session
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Difference between Data and Index Caches?
What is decode in static cache?
pmscmd startworkflow -sv
wat are deployement groups in informatica, how it will be used for developers
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What is meant by active and passive transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Differentiate between a database and data warehouse?
What are the new features of Power Center 5.0?
What is the difference between a repository server and a powerhouse?
What is a filter transformation?
Write the unconnected lookup syntax?
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 are the different types of repositories created using informatica?