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
if i am having 10 records in source, i want 20 records in target...how will you do it
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
What is a sequence generator transformation?
What is an incremental loading? in which situations we will use incremental loading
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
How informatica recognizes mapping?
How we can create indexes after completing the loan process?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?