how to import multiple flat files in to single target where
there is no common column in the flat files
Answers were Sorted based on User's Feedback
Answer / 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 |
how do u use sequence created in oracle in informatica? Explain with an simple example
what is procedure to use mapping variable in source qualifier transformation? with example
What are the new features of informatica 9.x at the developer level?
What are the advantages of using informatica as an etl tool over teradata?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
why we use stored procedure transformation?
What is resilience time?
what is unit testing?tell me proceedure
what is metadata?
how can we perform incremental aggregation?explain with example?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me