how to connect to a flatfile through ftp in informatica

Answers were Sorted based on User's Feedback



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 to connect to a flatfile through ftp in informatica..

Answer / Neha Chauhan

To connect to a flat file through FTP in Informatica, you can use the PowerCenter Integration Services (PIE) and the FTP Source Qualifier or Target Qualifier. You will need to provide the necessary connection details such as host, port, username, and password.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

what is the difference between cardinality and Nullability?

1 Answers  


Is hadoop a etl tool?

1 Answers  


I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  


What is a staging area? What is the purpose of a staging area?

1 Answers  


how do u really know that paging to disk is happening while u are using a lookup transform?

1 Answers  


explain the methodology of Data Warehousing?(Polaries)

1 Answers  


what is session partitioning?

1 Answers  


What is Data Vault???

1 Answers  


What is etl process. How many steps etl contains explain with example?

1 Answers  


I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

2 Answers   Accenture, Saama Tech, TCS,


flat filevalidation in informatica

1 Answers   Hewitt,


what is different between sequential batch and concurrent batch and which is recommended and why?

1 Answers  


Categories