How the Informatica Server reads perameter file?
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
What are the different options used to configure the sequential batches?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
In a sequential batch can you run the session if previous session fails?
what is mean by flag 4 in update strategy t/r
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
What is factless fact schema?
how much memory (size) occupied by a session at runtime
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what is confirmed dimension?
What is workflow manager?