1)how can we delete the cache files while we using aggregator transformaation?2)exlain about cache files handling in informatica3) there are two flat files and the two flat files contain two fileds as states.both the flat files contain duplicates how to eliminate this duplicates?4) can we use lookup transformation with out using source qualifier transformation?

  • Interview Candidate
  • 18
  • 8377

Showing Answers 1 - 18 of 18 Answers

calltomadhu

  • Nov 8th, 2006
 

hi,

i am not sure about 1 and 2 but i am telling about 3 and 4

3) select distinct values source qualifier to avoid duplicate rows.

4) no with our sq you cant

  Was this answer useful?  Yes

Anand.R

  • Nov 29th, 2006
 

2,cache types,static cachedynamicpersistentsharednamed and un-named3> using union-trans we can remove duplicates,since both tables having same fields and datatypes. in srq trans we cant use fla-files

  Was this answer useful?  Yes

Vikas Gupta(Bhubnaeswar(GE))

  • Dec 1st, 2006
 

1) We can reduce cache files size by placing a filter before Aggregator Trasformation.

Dont know abt delete..if anyone do let us know..

  Was this answer useful?  Yes

Ramesh

  • Feb 21st, 2007
 

cache are automatically deleted by the power ceter server(i.e Data cache and Index cache) after session completes

If you use persistent cache power center save that cache for further use

  Was this answer useful?  Yes

chandrarekha

  • Sep 28th, 2007
 

After the session executes,  DTM removes the cache memory and deletes cachefiles
Incase of persistant cache and incremtal aggregation cache files are saved.
Generally cache files are created in Informatica sever, no default memory is allocated for this, once memory exceeded than these (index,cache) files, You can see this in cache directory.

  Was this answer useful?  Yes

jayapraveen

  • Oct 13th, 2010
 

1.I think DTM remes the Cache files after successful loading the data into target
2.a.persistent cache
   b.staic cache

   c.shared cache
   d.dynamic cache
3.sorter before an union transformation in sorter check the property "Distinct"
4.yes we can join tables with out using source qualifier because lookup default executes left outer join

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions