how to connect to a flatfile through ftp in informatica
Answer Posted / 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 View All Answers
What is etl process?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What is partitioning? Explain different types of partitioning?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
how do u set partition points in the mapping?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Is apache nifi an etl tool?
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.
Identifying the bottlenecks in various components of Informatica and resolving them.
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What is the difference between project backlog and product backlog?
how would u estimate the size of Lookup transform data and index cache?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
List few etl bugs?