There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
What is the procedure for creating independent data marts from informatica 7.1?
Why we use partitioning the session in informatica?
what is the use of Java Transformation in Informatica 8.x?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
Write the advantages of partitioning a session?
How many ways are there to do 'remove duplicate records in informatica'?
What is the difference between view and materialised view?
How we will implement Pushdown Optimization and Types in Informatica with better examples
What is the use of incremental aggregation?
What is informatica powercenter repository?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?