DSXchange

Or....

Use Remove Duplicate Stage.
Keep the Last Record for Max value.
In Input link, SORT and PARTITION on PersonNumber and use only SORT for TimeStamp field in ascending order.

You will get one unique row for each personnumber with max date/time value.

Hope this helps.

Have you checked the Unicode in your source/target link?

Unfortunately you can not use link ordering in parallel transformer.

One work around will be to split the job design in two jobs.
Job 1 will do your step a (delete) and job 2 will do b & c (insert).
Use a sequencer to first run job 1 and then job 2.

Hope this helps

Hi Karthi, You have to use Vertical Pivot to get the desired result. Using a transformer, strip out the Year value from your input file and create a Year Column and Pivot on Amount with Array Size 12 with Group By on Asset_Id and Year. Also make sure to Sort the Input File on Asset_Id (Sorting and P...

Check to see if you can log into xmeta schema with the password you are using to install..

If you are using Current Date and Time for file creation.. then do the following:

Create the file with a generic name like outfile
Use After Job Subroutine and ExecSH and do the following:
mv outfile outfile.`date +"%m%d%y%H%M%S"`

Done!

soumya5891 wrote:You need to make a hash partition on each input link in the same order.The order of the hash keys will be same as join keys

Soumya is right. Just hash partition and also sort your input key column

Try changing the lookup Condition Not Met = Continue and LookUp Failed = Continue

Do this:
1.Use Remove Duplicate Stage.
2.Sort the Input Field in Remove Duplicate stage on eid and date with asc and make sure you use sort and partition on eid and only sort on date input field.
3. Keep the Last Row.

You will get the desired result.

In transformer stage, Sort the input Date Column in DESC order and using constraint send out the First Six Rows.

If you are running your job in parallel use this in constraint to filter the last 6 months: (((@INROWNUM -1) * @NUMPARTITIONS) + @PARTITIONNUM + 1) <= 6

Hope this helps

You can also use AlNum function

Keshav.. and then how to get the remaining rows (- first row) ?

Just jump in. Start with basic unix and have faith in google :D

Are you using Server or Parallel jobs?

I successfully installed IIS 8.5 on XP Pro VM and WinServer 2003 VM. I am going to try it out on SuSE VM next.. Will update you guys accordingly.