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 key benefits of ETL Testing?
what is a worklet?
What is a staging area? What is the purpose of a staging area?
What is data modeling and data mining?
what is the difference between shortcut of an object and copy of an object? compare them?
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.
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
Hi, Lookup() is what kind of join ?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?