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?
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
What is the different type of jobs in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the types of containers and how to create them?
Lookup constraints
What are the steps needed to create a simple basic datastage job?
What are the functionalities of link partitioner?
What are the job parameters?
What are system variables and sequencers in datastage
What is the difference between passive stage and active stage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Enlist various types of routines in datastage.
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
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)
What is the use of hoursfromtime() function in transformer stage in datastage?
How to reverse the string using SQL?