Answer / varma

Option1: You can use wc –l <<filename>> | awk '{print $1}'
in “Execute command” stage to get the row count.

Option2:-Read the sequential file and after the stage
finishes successfully, you can get the link count using
DSGetLinkInfo(DSJ.ME,
DSJ.ME, “Yourlinkname”,DSJ.LINKROWCOUNT)

Answer / mmmm

Hi Simha..,

If u know then only give proper ans otherwise Shutup ur
asloe.Our AllInterveiw Community give one golden award for
u.its a Simha "Gaaandu"

Answer / mandru naganji

in seq file set row number column and it will generate data like 1 to n depending onm num of rows.use sort satge desc order get last record.u will get count

Answer / simha

hi,

seq file --> go for options --> select row count.
then automatically updated.

How rejected rows are managed in datastage?

0 Answers  

---

what is time dimension? and how to populate time demension

2 Answers   TCS,

---

how do u catch bad rows from OCI stage? And what CLI stands for?

0 Answers  

---

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,

---

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,

---

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

---

What are the different options associated with dsjob command?

0 Answers  

---

2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?

1 Answers  

---

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

---

What are the processing stages?

0 Answers  

---

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

---

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 Answers  

---