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 / 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.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is an Integration service in Informatica?
Performance tuning( what you did in performance tuning)
Define sessions in informatica etl?
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.
Write the prerequisite tasks to achieve the session partition?
What does refresh system mean, and what are its distinctive choice?
What are session parameters ? How do you set them?
Differentiate between a repository server and a powerhouse?
how many types of dimensions are available in informatica?
Plz can any one say me how to get the informatica certification materials and dumps
What are the data movement modes in informatica?
What is the Process to creating lookup transformation in informatica
How to extract sap data using informatica? What is abap? What are idocs?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?