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

What are stage variables, derivations and constants?

1203

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2261

Differentiate between datastage and datastage tx?

1039

How many types of hash files are there?

1162

What is the difference between hashfile and sequential file?

1240

What is ibm datastage flow designer?

1127

If you want to use the same piece of code in different jobs, how will you achieve it?

1133

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

2847

What is the use of datastage designer?

1135

Can you explain engine tier in information server?

1109

Which warehouse using in your datawarehouse

2173

What are the main features of datastage?

1264

what is use of SDR function?

5157

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2797

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

992