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 / sankar
FOR THOSE FLAT FILE WE CREATE A LIST FILE.IN THAT LIST FILE
WE CAN ENTER FLAT FILE DIRECTRIES.
THEN GO TO SESSION
SOURCE TYPE:INDERECT
SOURCE DIRECTOTRY:LIST DIRECTORY
SOURCE FILENAME:LIST.TXT
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Could you explain what is enterprise data warehouse?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
scenario where i can use only concurrent execution of workflow.
Write the unconnected lookup syntax?
What is the commit type if you have a transaction control transformation in the mapping?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Have you worked with/created Parameter file
How many ways a relational source definition can be updated and what are they?
What is the difference between informatics 7x and 8x and what is latest version?
What is a difference between complete, stop and abort?
wf dont have integration severances how you can run?
How can a transformation be made reusable?
Mention few power centre client applications with their basic purpose?
explain about unit testing? in real time?