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

3) Sequential file contains data like
Empno ename sal
111 abc 2000
Trgt file:
Trgt1----111
Trgt2----abc
Trgt3---2000

Question Posted / prasad

Answers were Sorted based on User's Feedback



3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 ..

Answer / vamsi

hi,
it's simple one only
take sourse----->copy----> t1,t2,t3

in copy stage we map the in put columnes to out put as we required like col1 to t1,col2 to t2,col3 to t3...

Is This Answer Correct ?    18 Yes 0 No

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 ..

Answer / sindhu

transformer field function

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

How to initialize environment variables?

4 Answers   Infosys,

why dataset ?

2 Answers  

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,




what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,

options available in sequence job to run,validate?

0 Answers   CTS,

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers   HCL,

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories