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

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,


what is datastage job Monitoring

6 Answers   CTS,


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers   TCS,


if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  


What is APT_DUMP_SCORE?

2 Answers   IBM,


My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers   Wipro,


What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,


how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,


Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  


how can we create tables in datastage?

1 Answers  


How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  


Categories