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
What is decode in informatica?
Is it possible to create multiple domains on a single Informatica server?
What is an expression transformation in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to implement security measures using repository manager?
what is the -ve test case in your project.
How to update or delete the rows in a target, which do not have key fields?
What are the differences between oltp and olap?
What is meant by lookup transformation?
How to do unit testing in informatica? How to load data in informatica ?
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 ?
-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?
Is stop and abort are same in informatica?
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
list out all the transformations which use cache?