how to connect to a flatfile through ftp in informatica



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

Post New Answer

More ETL Interview Questions

what are the concerns of OLTP and DSS systems?

0 Answers   TCS,


What is a materialized view log?

0 Answers  


What is a mapping, session, worklet, workflow, mapplet?

0 Answers  


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

0 Answers  


how many maximum session supports to multiload in teradata ??

0 Answers   IBM,






Give the benefits of data integration suite?

0 Answers  


list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 Answers  


Compare ETL & Manual development?

0 Answers  


What are the types of Data Warehouse applications?

0 Answers  


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

0 Answers  


Identifying the bottlenecks in various components of Informatica and resolving them.

2 Answers  


Difference between flat files and relational sources?

0 Answers  


Categories