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 / rambabu
from sequential file connect copy stage
from capy take 2 o/p links and these o/p links conn to 2
transformer stages
next take funnel stage
in funnel set property funnel type=seq i thionk this is
solutions
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How can we improve performance of data stage jobs?
If you want to use the same piece of code in different jobs, how will you achieve it?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is a quality stage in datastage tool?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is usage analysis in datastage?
Demonstrate experience in maintaining quality process standards?
Differentiate between datastage and datastage tx?
Which warehouse using in your datawarehouse
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? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
how to abort the job its matain duplicates?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is orabulk stage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What are the types of views in datastage director?