You enter values in a schema file for RCP and you also entered
values in sequential file? which one will it take?



You enter values in a schema file for RCP and you also entered values in sequential file? which one..

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

Post New Answer

More Data Stage Interview Questions

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,


What is the default padding character?

3 Answers   IBM,


i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  


Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers   IBM,


I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,






How do u set a default value to a column if the column value is NULL?

7 Answers   HP,


Why we need datasets ratherthan sequential files?

5 Answers  


Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 Answers  


What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,


Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  


Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,


I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

3 Answers   IBM,


Categories