in my lookup table i want to catch the recently updated
records from the source to target,how to achieve this and what
is last commit interval point for this?
Answers were Sorted based on User's Feedback
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
How to elaborate powercenter integration service?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
What are the different caches used in informatica?
What are the mapping paramaters and mapping variables?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
Can you create a flatfile target
Explain lookup transformation in informatica
What is a code page?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
What is a rank transform?