how to load rows into fact table in data warehouse
No Answer is Posted For this Question
Be the First to Post Answer
What are mapplets?
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
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 data merging,data cleansing,sampling?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
have u done any performance tuning? how u ll do?
How do you load only null records into target?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?