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
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the advantages of using informatica as an etl tool over teradata?
Define filter transformation?
What are the issues you have faced in your project? How did you overcome those issues?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How might you approve all mappings in the archive all the while?
What is informatica worklet?
Can anyone tell me the new features in Informatica 9 Version?
What is workflow monitor?
Define update strategy?
How are indexes created after completing the load process?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain sessions. Explain how batches are used to combine executions?
What are mapplets?
-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?