Answer / naga

where you guys find filter option in sequential file

Answer / charan

hi this is charan
in sequential file there is no distinct keyword.But we use sequential file properties reject mode=output and then use remove duplicate stage based on key column(here we can't store the duplicate records).

Answer / kiran

Hai Venugopal..,

This is kiran............

I tryied but im not getting proper result...please try
again please intimate me.........

Thanks you...................

Answer / manoj

By using "DISTINCT" key word can remove all the duplicates
in the record or file .......

Answer / venugopal

Hi Vijay it's simple

In the source sequential file goto Output->Properties
under options you mention reject mode = Output.

This will gives the duplicate records in the output.

This will 100% work why because in my present project we
are using the same format.

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers  

What are the third party tools you used in your project?

1 Answers   IBM,

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   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,

if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,

what is executable in DataStage?

2 Answers  

tell me abt Datastage trigger?

1 Answers   HP, IBM,

how will u design file watch jobs?

2 Answers  

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers   HCL,