Can a joiner be used in a mapplet.
what are objects in data warehouse?
how do u tune queries?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
What is a unit Testing?
How many ways are there to do 'remove duplicate records in informatica'?
What are Target Options on the Servers?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Can we write to_date(three arguments) ? Will it work ? Advance thanks
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
Performance tuning in UNIX for informatica mappings?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
Does an informatica transformation support only aggregate expressions?