how to load rows into fact table in data warehouse


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,


What is limitations of truncate and load option

1 Answers   Cap Gemini,


what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,


How do you implement unconn. Stored proc. In a mapping?

1 Answers  


In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  






EXL informatica Questions

0 Answers  


Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,


HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,


i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,


with out using update strategy transnsformation how to update the data in mapping level

1 Answers  


What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,


Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  


Categories