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


Please Help Members By Posting Answers For Below Questions

How can we improve performance of data stage jobs?

620


If you want to use the same piece of code in different jobs, how will you achieve it?

644


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

675


What is a quality stage in datastage tool?

634


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

356






What is usage analysis in datastage?

824


Demonstrate experience in maintaining quality process standards?

1946


Differentiate between datastage and datastage tx?

601


Which warehouse using in your datawarehouse

1686


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?

1753


how to abort the job its matain duplicates?

2113


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2429


What is orabulk stage?

641


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

1476


What are the types of views in datastage director?

1249