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

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,


performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,


can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,


How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,


i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,


I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,


Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  


How to eliminate duplicates from flat file..what is the procedure

4 Answers  


if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


What is the difference between Normal load and Bulk load?

5 Answers  


Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  


Categories