What is the procedure for creating independent data marts from informatica 7.1?
No Answer is Posted For this Question
Be the First to Post Answer
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
Is it possible to define a single node as a Gateway node as well as worker node?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is repository manager?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
Can any one explain or sujjest some sites for scd mappings.Thank you
I have source like this 1:2;3. so i want to load the target as 123
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?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
In session log thier should not be a single error how will u do
How are the sources and targets definitions imported in informatica designer?