Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15528 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
What are snapshots?
how do u really know that paging to disk is happening while u are using a lookup transform?
What is the difference between Data Warehousing and Data Mining?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
what is the difference steps for data modeling?
what are the reports developed in sap bw project and what is the requirement for developing it?
what are the facilities provided by data warehouse to analytical users?
Can u access a repository created in previous version of Informatica?
Explain about the data integration suite features?
tell me few points when u become TL
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Explain etl mapping sheets?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what is the main role of FI on business
What is staging area referring to?
