How the dimensions will be loaded?
No Answer is Posted For this Question
Be the First to Post Answer
how to join the 2 different table with different columns in informatica?
what are surrogate keys?
How do we implement materialized view?when to use materialized view?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
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
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
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
what are the deliverables?in your project?
Is there any target staging area in informatica not staging area
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?
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
How to eliminate duplicates from flat file..what is the procedure