What are the types of error logs available in Informatica?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
How do you promote a non-reusable transformation to reusable transformation?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
Describe the impact of several join conditions and join order in a joiner transformation?
How can we use mapping variables in informatica?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
Can you access a repository created in previous version of Informatica?