Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suresh
if the source is database means we can delete the duplicate
records by enabling the option select distinct in source
qualifier t/r properties or by writing the following query
in source qualifier filter
delete from emp where rowid not in (select min(rowid) from
emp group by empno);
if the source is flat file means by enabling the option
distinct in sorter t/r we can delete the duplicate records
| Is This Answer Correct ? | 27 Yes | 1 No |
Post New Answer View All Answers
What is a dimensional model?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
design of staging area?
Explain the shared cache and re-cache?
What is xml source qualifier transformation in informatica?
What are the various types of transformation?
How to load a Dimension ? and how to load a fact table?
What are roles and groups and benefits of using them?
Write the different tools in the workflow manager?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Performance tuning in UNIX for informatica mappings?
Design a mapping to load a target table with the following values from the above source?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Explain pushdown optimization and types in informatica
