Answer / koti

seq -----------cg------------seq

Take input file like
1
2
3
4
5
6
7
8
9
10

comming to CG

Column Method =Explicit
column Generate = Test

go to cg Porperties output ----Mapping----- map the test column----ok

next ,column---edit column meta data--columnname test--sqltype integer----parallel properties---genartor-
type=cycle,increment =1,intial vlue=1.

go to target file do link sort to outputfile

go to apt_config file
check how many node is their

if it 2 nodes
you just create one more node that means total 3nodes.


while runing a job run on 3 nodes.

you will get output like
1
1
1
2
2
2
3
3
3
4

Answer / peeyush sehgal

Take input file like 0 1 2 3 4 5 6 7 8 9
seq -> trans -> seq

in transformer, clear its partitioning and sort the data.
then in stage variable
initialize sv=1

if inputlink%3=0 then sv+1 else sv

populate sv in output column.

Enlist various types of routines in datastage.

0 Answers  

---

What is lookup table?

5 Answers  

---

what is time dimension? and how to populate time demension

2 Answers   TCS,

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

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

0 Answers  

---

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  

---

what about data stage requirement

1 Answers  

---

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

2 Answers   IBM,

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---

How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

6 Answers   TCS,

---

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

---