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

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

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,


In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 Answers  


what about data stage requirement

1 Answers  


What is meta stage?

0 Answers  


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  






what is A Datastage?

2 Answers  


Is it possible to query a hash file?

0 Answers   IBM,


what is factless fact table?

3 Answers   IBM,


What are routines in datastage?

0 Answers  


1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,


if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 Answers  


i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want

3 Answers  


Categories