Eliminating of duplicate records without using dynamic lookups
Answer Posted / pooja ahmed
1. you can you use sorter transformation .... in that you
select distinct option
2. use agg trans .... in that go for group by
usi8ng above metyhod you can remove duplicate rec...
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
how many maximum session supports to multiload in teradata ??
how would u estimate the size of Lookup transform data and index cache?
Two default user groups created in the repository are____and_____.
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
what are the session parameters? How do u set them?
what make u disappointmnets in u r career
What is meant by incremental load?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What are materialized views & where do we use them?
what is a worklet?
Explain etl mapping sheets?