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

Hi I have scenario like this

s/r table T/r table
ename,sal empno,ename,sal
vijay,2000 1 , vijay, 2000
kumar,3000 2 ,kumar , 3000
ravi ,4000 3 ,ravi , 4000

How can i get target table like that without using
Transformer stage?

Question Posted / srinivasu

Answer Posted / srinivasu

This is an optional property. It adds an extra column of type unsigned BigInt to the output of the stage, containing the row number. You must also add the column to the columns tab, unless runtime column propagation is enabled.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which algorithm you used for your hashfile?

687

Describe link sort?

642

table actions available in oracle connector?

1090

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

611

What is meta stage?

577




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

667

Can you explain engine tier in information server?

650

What is the use of datastage director?

586

AGGREGATOR default datatype

931

How you Implemented SCD Type 1 & Type 2 in your project?

3695

How to RD using transformer?

857

How do u convert the columns to rows in datastage?

692

How can we improve the performance in datastage?

647

Define Merge?

874

What is the differentiate between data file and descriptor file?

863