Question { Satyam, 41297 }

What is Factless fact table ???

Answer

A Fact table without measures(numeric data) for a column is
called Factless Fact table.

eg: Promotion Fact(only key value available in FT)

Question { TCS, 34295 }

explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???

Answer

1)Bulkload & Narmal load

Normal: In this case server manager allocates the
resources(Buffers) as per the parameter settings. It creates
the log files in database.

Bulk: In this case server manager allocates maximum
resources(Buffers) available irrespective of the parameter
settings. It will not create any log files in database.

In first case data loading process will be time taking
process but other applications are not affected. While in
bulk data loading will be much faster but other application
are affected.

Question { TCS, 22410 }

What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?

Answer

This can be handled by using the file list in informatica.
If we have 5 files in different locations on the server and
we need to load in to single target table.In session
properties we need to change the file type as Indirect.

am taking a notepad and giving following paths and file
names in this notepad and saving this notepad as
emp_source.txt in the directory /ftp_data/webrep/

/ftp_data/webrep/SrcFiles/abc.txt
/ftp_data/webrep/bcd.txt
/ftp_data/webrep/srcfilesforsessions/xyz.txt
/ftp_data/webrep/SrcFiles/uvw.txt
/ftp_data/webrep/pqr.txt

In session properties i give /ftp_data/webrep/ in the
directory path and file name as emp_source.txt and file type
as Indirect.

Question { TCS, 22410 }

What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?

Answer

we can use Union Transformation to load multiple files into
single target.