You enter values in a schema file for RCP and you also entered values in sequen

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

1 Answers
7550 Views
TIAA CREF, I also Faced
E-Mail Answers

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

Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

7 Answers

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers IBM,

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers

Hai..,in datastage how to explain project in interview?please explain any domain please.

1 Answers Wipro,

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers Reliance,

How many input links can you give to a Transformer stage?

6 Answers

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

0 Answers

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers IBM,

in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?