How the dimensions will be loaded?
No Answer is Posted For this Question
Be the First to Post Answer
How is union transformation utilized?
How to elaborate powercenter integration service?
What are Rapid changing dimensions?
where is the reject loader .
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
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
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?
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.
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
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
can we override a native sql query within informatica? How do we do it?
WAT IS TEXT LOAD?