i have ten flat files with same structure,if
i want to load it to single target,and mapping needs to
should show only one source.what will be the steps to taken
to achieve it?/
Answer Posted / arnab
Concat all the files using a Unix shell script to create a
new file and use this as the source file
If you use windows create a dos batch script
Then call the Unix shell script before calling the session
in the workflow , so that the process is automated
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of code page?
Explain the features of connected and unconnected lookup.
How to create or import flat file definition in to the warehouse designer?
list out all the transformations which use cache?
What is the difference between source qualifier transformations source filter to filter transformation?
What are active transformations.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Define joiner transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is dimensional table? Explain the different dimensions.
Explain the different dimensions.
How would you join a node to the already existing domain?
Explain sessions?
How many number of sessions can one group in batches?
What are the modules in Power Center