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
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)
How many types of stage?
Can you explain players in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Where do you see different stages in the designer?
What are the types of hashed files in data stage
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are routines in datastage? Enlist various types of routines.
What is the difference between datastage and datastage tx?
In Datastage, how you can fix the truncated data error?
What are stage variables?
What are transforms and what is the differenece between routines and transforms?
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
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