what is service oriented architecture in Informatica 8 version
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
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
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How do you create single lookup transformation using multiple tables?
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain sessions. Explain how batches are used to combine executions?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
Can we combine a flatfile and a database table using an UNION transformation?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression