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

Does datastage support slowly changing dimensions ?

1108

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?

1503

How can you write parallel routines in datastage PX?

1015

Could anyone give brief explanation bout datastage admin

2355

What is "fatal error/rdbms code 3996" error?

1271

Why fact table is in normal form?

1256

What is the difference between hashfile and sequential file?

1262

How to implement complex jobs in data stage?

1112

How one source columns or rows to be loaded in to two different tables?

1130

How a source file is populated?

1068

Explain connectivity between datastage with datasources?

982

What are the types of containers and how to create them?

980

Have you used Unstructured data?

1323

To see hidden files in LINIX?

1531

what is repositery?

1845