There are two file are there .1st file contains 5 records and
2nd file contain 10 records in target they want 50 records.how
can achieve this

Answer Posted / vinod upputuri

use copy stage and funnel stage to make duplicate records.

SEQ>>COPY>>FUNNEL>>TARGET

the solution for this stupid question asked by interviewer:

SEQ>>COPY>>>4links>>>FUNNEL STAGE>>>SEQ.

in seq stage: sed -n '1,50p'

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How a routine is called in datastage job?

611


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1055


Explain connectivity between datastage with datasources?

605


Name the third party tools that can be used in datastage?

620


How will you move hashed file from one location to another location?

1663






What is the difference between an operational datastage and a data warehouse?

642


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

960


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4572


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

2017


What is use Array size in datastage

1313


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

657


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

2429


On which Dimension Table you implemented SCD Type in your Project

1588


How to clean the datastage repository?

700


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

545