There are n numbers of flatfile of exactly same format are
placed in a folder .Can we load these flatfile's data one
by one to a single relational table by a single session??

Answer Posted / bzz

Use source type as Indirect File Type and source file name
as a file having the names of all the n flatfiles to be
read.

Is This Answer Correct ?    32 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is decode in informatica?

742


Is it possible to create multiple domains on a single Informatica server?

869


What is an expression transformation in informatica?

634


in reporting we add some new objects,how we get the count of the newly added objects to the report

1862


How to implement security measures using repository manager?

695






what is the -ve test case in your project.

1975


How to update or delete the rows in a target, which do not have key fields?

762


What are the differences between oltp and olap?

630


What is meant by lookup transformation?

699


How to do unit testing in informatica? How to load data in informatica ?

750


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6323


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5143


Is stop and abort are same in informatica?

657


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1752


list out all the transformations which use cache?

772