How do you manage the Parameter files while migrating your data from one environment to another environment?
No Answer is Posted For this Question
Be the First to Post Answer
Can we override a native sql query within informatica?
Explain the difference between a data warehouse and a data mart?
How to eliminate duplicates in FF and oracle both
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
What is dimensional table? Explain the different dimensions.
how can we run workflow with pmcmd?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
how to call lookup qualifer in unconnected look;up
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is fact table? Explain the different kinds of facts.
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
explain abt joiner t/r?