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 is etl tool in hadoop?
What is a materialized view log?
Is apache nifi an etl tool?
Is hadoop a etl tool?
What is a staging area? What is the purpose of a staging area?
List few etl bugs?
how do u decide whether u need to do aggregations at database level or at Informatica level?
What is etl process. How many steps etl contains explain with example?
how do u really know that paging to disk is happening while u are using a lookup transform?
Can there be sub steps of etl steps?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?