What is different between the data warehouse and data mart?
No Answer is Posted For this Question
Be the First to Post Answer
explain abt joiner t/r?
Is informatica power center designer has 64 bit support?
What does cheating measurement mean?
Name the different lookup cache(s)?
Enlist few areas or real-time situations where informatica is required.
How to differentiate between the active and passive transformations?
I have source like this 1:2;3. so i want to load the target as 123
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 is rank transformation in informatica
How to create a non-reusable instance of reusable transformations?
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?