What is a standalone command task?
What are mapplets? How is it different from a Reusable Transformation?
Limitation of REPLACESTR. Is there any character limitation to it.
what is the difference between repository & Intergration service
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
What are the different caches used in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
how to design mapping half of source table records into one target and remaining half into another target
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?