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 |
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.
How to delete duplicate row using informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the different caches used in informatica?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
where to store informatica rejected data? How to extract the informatica rejected data?
how lookup is acting as both active and passive ? how is it possitble?
How to load data in informatica ?
can we import source table without using source qualifier? if yes then how? if no then why?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
what is the drillup & drill down?and use of the drill up and drill down?