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
- 14749 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bzz
Use source type as Indirect File Type and source file name
as a file having the names of all the n flatfiles to be
read.
| Is This Answer Correct ? | 32 Yes | 0 No |
Answer / amarnath
create a file list which is nothing but simple .txt file
which contains the name of the each file u want to load and
in session properties make source file as "indirect" and
give the path of the file list that u have created and run
the wkf
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / schwab
Hi,
Yes U can do it by merging all 10 flat files in one single
file.
create a script before session(presession) to merge all
these files into one.
This is the way we are handling in our project.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / harish konda
Yes we can load all these flat files in a single session.
First create a txt file and in that give all the file names
along with their PATH.
Drag any one of the flat file into the mapping and link it
to the target acc. to your requirement.
And in the session properties give the file type as Indirect
and in Filename option, give the file name(along with the
path) of the file in which you gave all the paths.
Then run the mapping.
| Is This Answer Correct ? | 1 Yes | 0 No |
Hi,,,TCS,,,
Have you attend Recently for TCS,,,?
You need to load 10flatfiles to One relational source,,?
You can keep 10flat files in a single folder.Just assign
the folder path as a Source path in SESSION PROPERTIES.
it will make it 1 flatfile source.
By a simple Mapping,make it single Relational source.
Any corrections,,,,,srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 4 Yes | 11 No |
Answer / rekha
YES YOU CAN DO IT BY USING FILE REPOSITORY
U CAN PLACE THAT FOLDER IN THE SESSION PROPERTIES
| Is This Answer Correct ? | 0 Yes | 7 No |
What is CDC? How to implement CDC?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
difference between source based commit? and target based commit? which is better with respect to performance?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is the role of informatica in project ?Like i showed financial projects?
Is there any target staging area in informatica not staging area
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
What is the different lookup cache(s)?
What is meant by query override?
How we can use union transformation?
HOW TO DELETE A RECORD FROM FLAT FILE
Teradata 
