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 / 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.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Difference between Data and Index Caches?
How do you handle two sessions in Informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is option by which we can run all the sessions in a batch simultaneously?
what is the difference between informatica6.1 and infomatica7.1
What is the function of look up transformation?
What is union transformation?
Explain the different lookup methods used 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 ?
How do we call shell scripts from informatica?
What do you mean by filter transformation?
Plz can any one say me how to get the informatica certification materials and dumps
What do you mean by enterprise data warehousing?
How many numbers of sessions can one group in batches?
What is joiner transformation?