in u flatfile some of fact records are missed then u load
the diminision records are not if u load diminsion records
what about fact table records
No Answer is Posted For this Question
Be the First to Post Answer
I have source like this 1:2;3. so i want to load the target as 123
What are set operators in Oracle
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
What is sq transformation?
What's the layout of parameter file (what does a parameter file contain?)?
in static and dynamic which one is better
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
Tell me one complex query in oracle ?
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
what are the output files that the informatica server creats during running a session?
what is metadata?
What are the types of lookup transformation?