how to import multiple flat files in to single target where
there is no common column in the flat files
Answer Posted / ramana sreepathi
in workflow session properties in Mapping tab
in properties
choose Source filetype Indirect
Give the Source filename : <file_path>
This <file_path> file should contain all the multiple files
which you want to Load
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What are the differences between oltp and olap?
How do you load only null records into target? Explain through mapping flow.
Explain sessions. Explain how batches are used to combine executions?
Mention few advantages of router transformation over filter transformation.
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What does reusable transformation mean?
-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?
What is mapping debugger?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
can we override a native sql query within informatica? How do we do it?
What is the difference between a repository server and a powerhouse?
What are the components of Informatica? And what is the purpose of each?
Differentiate between sessions and batches?
Explian the Process of deployment groups in informatica
Differences between version 7.x and 8.x.