What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?
Answer Posted / deepu
To load 5 differnt files of same format .first creat a
directory in Unix and copy all the file into this directory
and using the option as Indirect load in session properties
give the loaction of unix in source and it will enable to
load all the 5 files in single run in to a target . if we
have 5 diff files in 5 different formats then firstly
convert all in to one format and then proceed as explained
aboue.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What does cheating measurement mean?
What does reusable transformation mean?
What will be the approach?
how tokens will generate?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How might one distinguish in the case of mapping is right or not without associating session?
Why filter transformation is an active one?
What is lookup change?
what is diff b/t sorter t/r and agg have the option sorter property...
What is the use of source qualifier?
What is the need for an etl tool?
What is joiner change?
In development project what is the process to follow for an etl developer from day1
What is workflow manager?
Mention few advantages of router transformation over filter transformation.