How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.
Answer / isha
We can use contraint based loading in that case and after loading all the dimensions table we can load the data into fact table.
Is This Answer Correct ? | 0 Yes | 0 No |
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
what is hash table in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is depict expression change?
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
From where we can start or use pmcmd?
How can we integrate different flat file data in a single mapping and with in a single execution
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?