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...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

source file is having 5 records while moving into target it
want to be 10 records

Question Posted / narra

Answers were Sorted based on User's Feedback



source file is having 5 records while moving into target it want to be 10 records..

Answer / rajesh

Hi This is Rajesh. use copy stage for multiple copies.From that take 2 links to funnel n load to target ...u wil get 10

Is This Answer Correct ?    15 Yes 0 No

source file is having 5 records while moving into target it want to be 10 records..

Answer / sravanthirao64@gmail.com

target can create instance

Is This Answer Correct ?    6 Yes 4 No

source file is having 5 records while moving into target it want to be 10 records..

Answer / srikanth

it's not a big issue create a one more node extra and select
the partition entire and run the job


thanks & regards
sriaknth.k
9573056597

Is This Answer Correct ?    5 Yes 4 No

source file is having 5 records while moving into target it want to be 10 records..

Answer / subbuchamala

Different ways are:

1. SRC-->COPY-->(2links)-->FUNNEL-->TGT
from copy stage get 2 copies of output data and send to funnel.

2. SRC-->Transfermer-->(2links)-->FUNNEL-->TGT
in the TFM, map the all the columns to both the links and then funnel them.

3. SRC--->TGT(with append mode)
Run job 2 times with TGT Seq file mode as "Append"

4. 2 SRCs(2 same Seq file Stages)-->Funnel-->TGT
read the same file from 2 Seqfile Stages and send them to funnel.

5. SRC--->TGT
Add 2 "File" properties in the Seq file stage and for both of them give the same file name and path.

File=directory/file.txt
File=directory/file.txt

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

Define APT_CONFIG in Datastage?

0 Answers  

how CAN we remove duplicates in dataset?

2 Answers   IBM,

can we half project in parallel jobs and half project in server jobs?

4 Answers   Infosys, L&T,

INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

11 Answers   CTS,

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,

What are the differences between datastage and informatica?

0 Answers  

What are the stages in datastage?

0 Answers  

can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 Answers  

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

For more Data Stage Interview Questions Click Here
Categories