Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15262 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
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
How to fine tune mappings?
Explain different types of partitioning?
how would u estimate the size of Aggregator transform data and index cache?
Mention few test cases and explain them?
What is initial load and what is full load?
how do u set partition points in the mapping?
What is a lookup table in etl?
What are your responsibilities as an etl tester?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what is Forward,Reverse and Re_engineering?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
what do u do when DB time takes more?in sap bi
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
