how to load dimension table and fact table. plz tell me the
steps.
No Answer is Posted For this Question
Be the First to Post Answer
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
What is persistent lookup cache?
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
wt is Dynamic lookup Transformation? when we use?how we use?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
Explain why we use partitioning the session in informatica?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
what are the deliverables?in your project?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is union transformation in informatica?
tell me about your project functionality