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.

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,

---

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

---

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

---

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

---

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  

---

Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers   IBM,

---

How do u view log file for a particular job?

6 Answers   HP,

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

1 Answers  

---

Which commands are used to import and export the datastage jobs?

1 Answers  

---

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

---

Where do you see different stages in the designer?

1 Answers  

---

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

---