What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?
Answer Posted / dragon
I have a query, suppose i have 6 file in 3 different ftp
server with same file structure and i want to load data
using single mappping. In this case how can we use filelist.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Target increases every day even though no new record was inserted
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is lookup change?
Differentiate between router and filter transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the Rank index port in Rank transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is a stored procedure transformation?
How many types of sessions are there in informatica.please explain them?
What is dynamic cache?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are ETL Tools?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?