Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Answers were Sorted based on User's Feedback



i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,..

Answer / satyanarayana

take one copy stage and then take two output links from copy
stage and next these two o/p links given to funnel stage and
provide option called 'sequential mode' in funnel stage then
you will get req output.

Is This Answer Correct ?    18 Yes 3 No

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,..

Answer / venugopal

Take source in the sequential file and take two copy stages
and map the columns to two copy stages and use funnel stage
to funnel the data from two copy stages and o/p into the
file now you can see the o/p is your requirement....

Hope this will help you...

Is This Answer Correct ?    5 Yes 4 No

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,..

Answer / raj

Hello Chowdary... Using one source file only not two source
files he is asking first look into the question and answer
in the proper way...

Is This Answer Correct ?    3 Yes 3 No

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,..

Answer / sarath

HEY GUYS....ANS #4 IS CORRECT AND I CHECKED IT.

Is This Answer Correct ?    1 Yes 2 No

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,..

Answer / amit

read the file from sequential file stage, use a transformer in between, write the same data to the same file using sequential file stage as target by setting option to - load file in append mode.

Is This Answer Correct ?    0 Yes 1 No

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,..

Answer / 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

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,..

Answer / 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

More Data Stage Interview Questions

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,


what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,


I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,


i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me

0 Answers  


How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,


i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,


Please tell me What is difference between 8.0 and 8.1

1 Answers   IBM,


i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,


Is the value of staging variable stored temporarily or permanently?

0 Answers  


how can we join one oracle & flat files ?

2 Answers   ME,


Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers   Amdocs,


Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,


Categories