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

How to Convert the columns into rows?

2 Answers  

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers  

Why do you need stage variables?

0 Answers  

What are the types of hashed files in data stage

0 Answers  




how to abort the job its matain duplicates?

0 Answers   TCS,

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,

detail about sdlc

4 Answers  

Differentiate between datastage and informatica?

0 Answers  

Whats difference betweeen operational data stage (ods) and data warehouse?

0 Answers  

What is the purpose of pivot stage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories