Answer Posted / ramjanaki
I think you are referring to the Mapping of Columns in the
Transformer Stage.
It is nothing but relating the columns from the source
stage to the target in the Transformer stage by drag and
drop. Transformations like for example, doing some
condition check, applying some functions etc., can be done
here and the resultant data will be loaded to the target.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are routines in datastage? Enlist various types of routines.
What is staging variable?
Difference between server jobs & parallel jobs?
What is a merge?
What is the difference between hashfile and sequential file?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Describe the architecture of datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
how to delete one row in target dataset
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How many types of hash files are there?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How do you import and export the datastage jobs?
What are the various kinds of containers available in datastage?
What is the difference between odbc and drs stage?