Answer Posted / suresh
hi all
if we have two records with same data
i mean duplicate records
at that time how the is calculated for that
let me know
example
name,age
suresh,23
ramesh,25
suresh,23
murali,20
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Global and Local shortcuts. Advantages.
How is union transformation utilized?
What is resilience time?
What is a dimensional model?
Differentiate between source qualifier and filter transformation?
What is the commit type if you have a transaction control transformation in the mapping?
What is workflow monitor?
What is xml source qualifier transformation in informatica?
Explain the different lookup methods used in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
what is Active lock explain
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain what is informatica metadata and where is it stored?
What is option by which we can run all the sessions in a batch simultaneously?