How can we create index after completion of load process?
No Answer is Posted For this Question
Be the First to Post Answer
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
What is a unit Testing?
How do you load unique records into one target table and duplicate records into a different target table?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
How we will implement Pushdown Optimization and Types in Informatica with better examples
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
How to improve the performance of Aggregate transformation?