How can we create index after completion of load process?


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

Post New Answer

More Informatica Interview Questions

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,


What is a unit Testing?

1 Answers  


How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  


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

2 Answers   Zensar,


How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  






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

1 Answers  


How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,


What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  


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

6 Answers   TCS,


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

7 Answers   Deloitte,


How to improve the performance of Aggregate transformation?

3 Answers   Dmss,


Categories