Un-Answered Questions { Data Warehouse }

To import the flat file definition into the designer where should the flat file be placed?

677


How are the sources and targets definitions imported in informatica designer?

671


What are the data movement modes in informatica?

703


How to generate or load values in to the target table based on a column value using informatica etl tool.

611


Explain sql transformation in script mode examples in informatica

605


What are Dimensional table?

619


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

678


While importing the relational source definition from the database, what are the metadata of source that will be imported?

793


Explain the mapping variable usage example in informatica

635


Why sorter is an active transformation?

754


Under which circumstances, informatica server creates reject files?

591


Explain the pipeline partition with real time example?

656


What is the need of an ETL tool?

643


What are the types of lookup transformation?

631


Explain pushdown optimization and types in informatica

668