What is predefined event?
How many joins in Informatica
what is Active lock explain
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
How to enter same record twice in the target table,explain?
Where can we find the throughput option in informatica?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
How to load the source table into flat file target(with columns) in informatica?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
How will you display "Mr" for male & "Mrs" for female in target table?
what are cost based and rule based approaches and what is the difference?