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 to join the 2 different table with different columns in informatica?

5 Answers   Accenture,


what are surrogate keys?

5 Answers  


How do we implement materialized view?when to use materialized view?

1 Answers   TCS,


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

1 Answers  


i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,






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

2 Answers  


delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,


what are the deliverables?in your project?

0 Answers   DELL,


Is there any target staging area in informatica not staging area

0 Answers   Syntel,


hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,


IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,


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

4 Answers  


Categories