bhagya


{ City }
< Country > india
* Profession *
User No # 17879
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 6
Users Marked my Answers as Wrong # 2
Questions / { bhagya }
Questions Answers Category Views Company eMail




Answers / { bhagya }

Question { IBM, 13797 }

Eliminating of duplicate records without using dynamic lookups


Answer

1) By enabling the option in sorter transformation as
select distinct
(or)
2) By enabling all the values as group by in aggreagator
transformation

Is This Answer Correct ?    3 Yes 1 No

Question { 6102 }

Hello all,

Source Table(Flat File):- Target Table(Flat File):-

Date Date

01/08/2008(DD/MM/YYYY) 01/08/2008
02/08/2008
03/08/2008
04/08/2008
05/05/2008

My requiremnt is this. I need to do it by informatica,Plz
tell me how can i do it?

Thanks





Answer

In expression transfromation
to_date(datecolumnname,dd/mm/yyyy) and pass this link upto
target

Is This Answer Correct ?    3 Yes 1 No