Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Is there any way to read the ms excel datas directly into informatica?
Explain what are the different types of transformation available in informatica.
In dimension and fact table? which one holds big data?
What is the main difference between a Joiner Transformation and Union Transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
what are the output files that the informatica server creats during running a session?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
What is joiner cache?
In warehouses how many schemas are there?
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?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
How union transformation is active ?