i have source data like
empno,enmae
11 ,aa
12 ,bb

i want output like
empno,ename
11 ,aa
12 ,bb
11 ,aa
12 ,bb

Answer Posted / chowdary

Take 2 sequentalfiles target dataset and processing funnel
stage.

note: Take similar structure we need common column names,
common datatypes then merging this process.....

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1905


How many types of stage?

684


Can you explain players in datastage?

713


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2710


Where do you see different stages in the designer?

637






What are the types of hashed files in data stage

650


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

2999


What are the main differences you have observed between 7.x and 8.x version of datastage?

626


What are routines in datastage? Enlist various types of routines.

631


What is the difference between datastage and datastage tx?

600


In Datastage, how you can fix the truncated data error?

645


What are stage variables?

641


What are transforms and what is the differenece between routines and transforms?

620


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

370


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1755