top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

Informatica issue - transformation

+2 votes

I want to know how to get latest updated record via Informatica. Suppose I have 10 records in a temporary table. 3 records for Account1, 3 for Account2 and 4 records for Account3. Now out of these 3 accounts, I need fetch only those records which has maximum date value (Latest date) and insert in another temporary table. So which transformations I could use to get this or informatica logic I should use? Please help

posted Apr 3, 2014 by Madhavi Kumari

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

1.If the Date column comes from input with unique date , based on that use the aggregator transformation and take the maximum date.
2.If no date column is present, please assign system timestamp but cannot take maximum date from this. You have to go for some other logic like rowid and rownum features.

answer Apr 4, 2014 by Shweta Singh
Similar Questions
0 votes

Teradata : JANUVIA - 50MG – TABLET - 1 BLISTER - 28 TABLET (28.TA) ORacle: JANUVIA - 50MG ? TABLET - 1 BLISTER - 28 TABLET (28.TA)

We are using code page 'ms windows latin 1 (ansi) superset of latin1' for source connection i.e. Teradata.

We are using code page UTF 8 for target

0 votes

My source is dat file. Intially in designer I can I import the file from my local. But later it gonna to come in shared location and Informatica need to pick it from there. I guess, for this I need to put parameter value 'Source file Directory' = '$PMSourceFileDir\' at session level in Workflow Manager. Now where is this Parameter file located? How can I get it to edit it so that I can put my parameter value also. Informatica is installed in my local but I am connecting to the repository of remote. Is there any other way so that Informatica can pick this dat file from a remote location. Please help.

Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.