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 / srinu
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 |
Post New Answer View All Answers
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
waht type of interface is used for testing the data in informatica
expain about the tune parameters?
What is a surrogate key?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How do you migrate data from one environment to another?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the advantages of using informatica as an etl tool over teradata?
What is intricate mapping?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is Cognos script editor?
Define mapplet?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
without table how to come first record only in oracle?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.