how to connect to a flatfile through ftp in informatica
Answer / sri
Create FTP connection in workflow manager. In
session->mapping, assign created ftp connection to
source(flat file).
| Is This Answer Correct ? | 10 Yes | 2 No |
how many steps are there in etl process?
What are the ETL Testing Operations?
how does the server recongnise the source and target databases.Elaborate on this
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what is a test load?
What is etl process. How many steps etl contains explain with example?
what is SMP AND MPP?
SCD2 will work on only dimension tables as well as fact Table?
how do u identify the changed records in operational data?
where are the log files generally stored.Can you change the path of the file.what can the path be?
How to know informatica conslole password??
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.