Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15703 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bhagya
1) By enabling the option in sorter transformation as
select distinct
(or)
2) By enabling all the values as group by in aggreagator
transformation
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
how many maximum session supports to multiload in teradata ??
what is the difference steps for data modeling?
Explain about enterprise scalability and roi of data integration suite?
How many steps etl contains explain with example?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Explain different types of partitioning?
Which transformation we use to convert 'NA' to 'Not Available'
What is staging area referring to?
Can u access a repository created in previous version of Informatica?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
What is a lookup table in etl?
Define Dynamic push down optmization?
Identifying the bottlenecks in various components of Informatica and resolving them.
what are Lookup caches options? Including persistent caches.
