Answer / bharath

Hi,
in derivation for seq2 give as follows,
for file name give job parameter as file name and datatype is char..
for timestamp give Current CurrentTimestamp()
for count rows it is not not possible by using transformer
it can be achieved by adding another stage
that is aggregation stage..

Answer / ankita, cgi

Hi,
I have tried to get this output, i got the idea upto some
extent,
Could you please Elaborate your solution? how to get this
exact output, i.e., (10|xyz.txt|20101110 00:00:00), except
count.

Thanks in Advance.

Answer / kirill lychagin

I managed to make such job in IIS 8.5, but i think it can be reproduced in all 8.* versions/

Main question is how to get rows count in transformer. In general it can't be done. But we have sequential file stage as target.

So my solution:
1) name of 1st target file is job parameter.
2) on link to 2nd target file we add to columns:
FNAME=#FIRSTTARGETFILE# - name of 1st target file
ROW_NUM=@INROWNUM - number of input row
3) on input link to 2snd sequntial file set Collector Type=Ordered and set ROW_NUM as sort key column
4) Then in 2nd Sequntial File Stage at tab Properties add "Filter" in Options category and write there "head -n 1"

Profit!

SO the idea is to get column num in transformer and apply unix style filter (mks on Windows) on output to Seq File.

Answer / akila

Pass the name of the file in a parameter, say p1.If your
count of rows flowing through the transformer is not huge,
the run the transformer in sequential stage and pass
@INROWNUM:'|':p1:'|':DSJobStartTimeStamp as a value of a
field. Add a tail stage in between the transformer and the
2nd file. In the tail stage, input 1 as the count of
records.

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

---

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

---

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

---

How do u view log file for a particular job?

6 Answers   HP,

---

how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,

---

what is meta data? Explain? Where it is used?

9 Answers  

---

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

---

Lookup constraints

0 Answers   CTS,

---

How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,

---

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,

---

where we use config file as parameter ?

1 Answers   IBM,

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---