what is surrogatekey ? In ur project in which situation u has used ? explain with example ?6 10922
what happens if you try to create a shortcut to a non- shared folder?1 5369
what is difference between dimention table and fact table?1 7176
What is data merging,data cleansing,sampling?4 7991
What is IQD file?1 4366
How do you handle decimal places while importing a flatfile into informatica?1 7951
what is the exact meaning of domain?3 21416
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?1 3795
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain the different dimensions.
What does command task mean?
How do you promote a non-reusable transformation to reusable transformation?
How is union transformation utilized?
What is a pre-defined event and user-defined event?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain lookup transformation source types in informatica
What is difference between a gateway node and worker node?
Which is the t/r that builts only single cache memory?
what is size of u r database?
What are the static cache and dynamic cache in informatica?
What are the uses of etl tools?
In informatica workflow manager, how many repositories can be created?
How many transformations can be used in mapplets.