what is the size of u r project? and what is the size of
source file?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
can we use mapplet as starting n ending object in mapping
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
what is the significance of newlookup port in dynamic look up
Slowly changing dimensions, types and where will you use them
h0w many versions have been developed of onformatica so far?
What is a shortcut and copy in Informatica and how two are different with each other?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
What is persistent lookup cache?
What is substr in informatica?
can every transfomation reusable?how?