What is different between the data warehouse and data mart?


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

Post New Answer

More Informatica Interview Questions

explain abt joiner t/r?

1 Answers   IBM,


Is informatica power center designer has 64 bit support?

1 Answers  


What does cheating measurement mean?

0 Answers  


Name the different lookup cache(s)?

0 Answers  


Enlist few areas or real-time situations where informatica is required.

0 Answers  






How to differentiate between the active and passive transformations?

0 Answers  


I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,


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 is rank transformation in informatica

0 Answers   Informatica,


How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,


1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,


How to handle decimal places while importing a flatfile into informatica?

0 Answers  


Categories