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 you migrate data from one environment to another?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
Write the prerequisite tasks to achieve the session partition?
How union transformation is used?
What is target designer and target load order?
Can i create a lookup table without cache.
What is decode in static cache?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.