what is lookup ?7 9128
what is the flow?1 4762
In update strategy target table or flat file which gives more performance ? why?7 17260
Why touse stored procedure in ETL Application?2 7631
What is critical mapping?2 7147
How to view and Generate Metadata Reports?1 4812
what is the gap analysis?1 6394
How to recover sessions in concurrent batches?3 11008
what are the different types of transformation available in informatica and what are the mostly used ?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the types of presistent cache in look up tr.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Slowly changing dimensions, types and where will you use them
how tokens will generate?
without table how to come first record only in oracle?
explain one complex mapping with logic? sales project?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. firstname.lastname@example.org Thanks in advance
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Performance tuning in UNIX for informatica mappings?
what is song in infrmatica...?