You enter values in a schema file for RCP and you also entered
values in sequential file? which one will it take?
Answer / ankit gosain
Hi All,
If you have enabled Run-Time Colum Propagation in your job
and you have created a Schema file, then it doesn't matter
that you define the metadeta in your sequential file or not
because datastage will always take the metadata from the
Schema File. And you'll define the metadata in Seq. file as
well then it will be overwritten at the run time on the
basis of Schema File.
Cheers,
Ankit :)
| Is This Answer Correct ? | 8 Yes | 0 No |
how to write server Routine coding?
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
Difference between the Sequence and Sequencer in DS?
Describe link sort?
count number of deptno in a emp table?
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
How to display errors in datastage?
How you can fix the truncated data error in datastage?
What is the difference between orabulk and bcp stages?
Can you define merge?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?