HOW TO YOU LOAD TIME DIMENSION
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
What is sorter transformation?
How to load a Dimension ? and how to load a fact table?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
sample mappings for scd1,scd2 and scd3
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
how to import multiple flat files in to single target where there is no common column in the flat files
What is a code page?