sequentialfile-----copy-----head and tail(in that we have options like no o

i/p o/p1 o/p2
1 1 4
1 1 5
1 1 6
2 2
2 2
2 2
3
3
4
5
6
how to populates i/p rows into o/p1&o/p2 using datastage
stages?and also the same scenario using sql?

Question Posted / kavitha

8 Answers
13988 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / kavitha

sequentialfile-----copy-----head and tail(in that we have options like no of rows=6 for head and n..o..r=4 for tail)then connect two data sets to that head and tail u will get

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain how a source file is populated?

1417

how to sort two columns in single job in datastage.

2957

Highlight the main features of datastage?

1220

how to export or import the jobs in .ISX file

1251

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2501

which r the connectors used in san?

2230

Name the command line functions to import and export the DS jobs?

1200

What are the primary usages of datastage tool?

1129

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

969

What are stage variables?

1255

How do you generate sequence number in datastage?

1140

Distinguish between informatica & datastage. Which one would you choose and why?

1043

To see hidden files in LINIX?

1589

What are the functionalities of link partitioner and link collector?

1061

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2267