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

What can we do with datastage director?

0 Answers  


How do you start developing a datastage project?

0 Answers  


What are sequencers?

0 Answers  


Differentiate between datastage and informatica?

0 Answers  


how to handle null values in sequential file?

1 Answers   HCL,






What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  


what is the definitions for Datawarehose and Datamart?

4 Answers  


source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,


how many rows sorted in sort stage by default in server jobs

0 Answers   Syntel,


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?

2 Answers  


source contains 2 columns comes to target 4 columns how

1 Answers   IBM,


how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,


Categories