Answer / rajkumar bachu

This can be handled by using the file list in informatica.
If we have 5 files in different locations on the server and
we need to load in to single target table.In session
properties we need to change the file type as Indirect.

am taking a notepad and giving following paths and file
names in this notepad and saving this notepad as
emp_source.txt in the directory /ftp_data/webrep/

/ftp_data/webrep/SrcFiles/abc.txt
/ftp_data/webrep/bcd.txt
/ftp_data/webrep/srcfilesforsessions/xyz.txt
/ftp_data/webrep/SrcFiles/uvw.txt
/ftp_data/webrep/pqr.txt

In session properties i give /ftp_data/webrep/ in the
directory path and file name as emp_source.txt and file type
as Indirect.

Answer / deepu

To load 5 differnt files of same format .first creat a
directory in Unix and copy all the file into this directory
and using the option as Indirect load in session properties
give the loaction of unix in source and it will enable to
load all the 5 files in single run in to a target . if we
have 5 diff files in 5 different formats then firstly
convert all in to one format and then proceed as explained
aboue.

Answer / arnab

Use Union transformation , if you do not want to use Union
and if your informatica runs on Unix , then create a shell
script to concatenate these files and create a single
file , you can call this shell script before you call the
session in the workflow

If you use windows create and dos batch script and do the
same as above

Answer / 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.

Answer / jayeshmumbai

Can use Union.

Answer / ghk

This can be handled by using the file list in informatica.
If we have 5 files in different locations on the server and
we need to load in to single target table.In session
properties we need to change the file type as Indirect.

Answer / satyam

Hope we can use union transformation.

Answer / rajkumar bachu

we can use Union Transformation to load multiple files into
single target.

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  

Define filter transformation?

0 Answers  

What are pre and post-session shell commands?

0 Answers  

what type of problem you faced insales project or insurance project

1 Answers   Sony,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com

0 Answers  

Enlist few areas or real-time situations where informatica is required.

0 Answers  

Can you start a batches with in a batch?

1 Answers  

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,