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
How do you load only null records into target? Explain through mapping flow.
What is the Rank index port in Rank transformation?
What are junk dimensions?
What is meant by active and passive transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Can u generate reports in Informatica?
How many types of sessions are there in informatica.please explain them?
What is a mapplet/worklet in informatica?
What is lookup transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is meant by incremental aggregation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Plz can any one say me how to get the informatica certification materials and dumps
Explain the different kinds of facts.
What is the cumulative sum and moving sum?