Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 9 Answers
- 14731 Views
- TCS, I also Faced
- E-Mail Answers
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 would you copy the content of one repository to another repository?
What is a pre-defined event and user-defined event?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the performance considerations when working with aggregator transformation?
What is a repository? And how to add it in an informatica client?
What are the guidelines to be followed while using union transformation?
How to implement security measures using repository manager?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
difference between repository database and repository service?
Have you worked with/created Parameter file
Separate from an archive server and a powerhouse?
What is difference between a gateway node and worker node?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How can we update a record in the target table without using update strategy?
Sequence generator, when you move from develoment to production how will you reset
