1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / revanth


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

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,

How can we run same job in 1 day 2 times

4 Answers   IBM,

options available in sequence job to run,validate?

0 Answers   CTS,




Define ds designer?

0 Answers  

1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,

How to display all the duplicate records from the oracle Table?

3 Answers   IBM,

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  

What are the stages in datastage?

0 Answers  

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers  

For more Data Stage Interview Questions Click Here
Categories