What is the procedure to load the fact table.Give in
detail?
Answer / dr.journalist
Fact table basically consists of Foreign keys which are
taken from the primary keys of all dimension as well as
facts.
So, for this reason take all the dimensions as Unconnected
lookups and try to take the foreign keys and at the same
time try to use the avaialble sources and make all possible
facts with the necessary transformations.
| Is This Answer Correct ? | 2 Yes | 4 No |
How the informatica server sorts the string values in Rank transformation?
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
What is source qualifier?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is InformaticaPowerCenter?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
How can we eliminate duplicate rows from flatfile,explain?
Why you use repository connectivity?
In which scenario did you used pushdown optimization?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties