Answer / vijayreddy

Hi Please find the dfd

seqfile--->T/R--->filter---->ds

in T/R stage u can take one etc column(SEQNO)that u can pass to next stage at same time u can create two stage varibles(sno1,sno2) this stage varibles u can call the filter stage in where class like(SEQNO between #sno1# and #sno2#

& then u can run job .That parameters values run time u can give the recored

Answer / akila ramu

Sample stage can be used for this. Sample stage when run in
period mode and N is mentioned, every Nth record from the
input is sent to the output.

For eg., period number=5 and maximum value=20 then 5, 10,
15 and 20th records are alone sent to the output.

Answer / ankit gosain

Hi All,

Ans1: In the source sequential file, you can specify the
read method from specific file to file pattern, so that it
can take the file on daily basis.
like:-you are getting the files ALSSM_12122012.dat,
ALSSM_13122012.dat, ALSSM_14122012.dat and so on which is
just appended by the date with file name. for this, you can
specify a file pattern like <path>/ALSSM_*.dat

Ans2: SeqFile--->Transformer--->Tgt
create two parameters of integer type in your job (say Val1
& Val2) &
In transformer stage, define a constraint:
@INROWNUM=Val1 OR @INROWNUM=Val2 (Where @INROWNUM is a
System Variable). Now you can assign the value of Val1 &
Val2 at the run time.

For more queries, mail me on ankitgosain@gmail.com

Cheers,
Ankit :)

how to abort the job its matain duplicates?

0 Answers   TCS,

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

How many areas for files does datastage have?

0 Answers  

---

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,

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,

---

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers   Alpharithm Technologies,

---

Which warehouse using in your datawarehouse

0 Answers   IBM,

---

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

---

How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,

---