In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation.
If millions of files are there, how can we enter the flat file names in list file?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
What is deployemnt groups, Lables, query and dynamic deployment group.
can u give example for factless fact table
what are factless facts? And in which scenario will you use such kinds of fact tables.
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
can every transfomation reusable?how?
What are connected or unconnected transformations?
how to we create datamart?
where actually the usage of push down optimization happens...
Write the unconnected lookup syntax?
Define informatica repository?
How to load time dimension?