Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15342 Views
- IBM, I also Faced
- E-Mail Answers
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
What are the modules in Power Mart?
What is the difference between Data Warehousing and Data Mining?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
what are the data modeling tools you have used?(polaris)
Compare ETL & Manual development?
What is Data Vault???
Explain about the data integration suite features?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
What do you understand by active and passive transformations?
what is the use of server manager?
what make u disappointmnets in u r career
Mention few test cases and explain them?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
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.
