How the dimensions will be loaded?


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

Post New Answer

More Informatica Interview Questions

How is union transformation utilized?

1 Answers  


How to elaborate powercenter integration service?

1 Answers  


What are Rapid changing dimensions?

1 Answers  


where is the reject loader .

1 Answers  


we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,


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,


in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,


I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  


if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,


2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,


can we override a native sql query within informatica? How do we do it?

1 Answers  


WAT IS TEXT LOAD?

3 Answers   Wipro,


Categories