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 |
what are the concerns of OLTP and DSS systems?
What is a materialized view log?
What is a mapping, session, worklet, workflow, mapplet?
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
how many maximum session supports to multiload in teradata ??
Give the benefits of data integration suite?
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
Compare ETL & Manual development?
What are the types of Data Warehouse applications?
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?
Identifying the bottlenecks in various components of Informatica and resolving them.
Difference between flat files and relational sources?