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
- 14376 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
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.
What is a rank transform?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
whats the logic to load the lower level of granularity of data to fact table.
Can we override a native sql query within informatica?
What is a transaction control transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
Explain target update override in informatica
have u done any performance tuning? how u ll do?
How to elaborate powercenter integration service?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Where is metadata stored?
How to join three sources using joiner?
How many ways are there to do 'remove duplicate records in informatica'?
what is $$$$?
