What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
Answer Posted / 9019
Sorter select distinct, aggregator group by columns
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can u give example for factless fact table
What do you understand by term role-playing dimension?
How to elaborate powercenter integration service?
Why sorter is an active transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is an aggregator transformation?
What is enterprise data warehousing?
What is data caches/ index caches?
draw informatica architecture 8.6 ?
How to do unit testing in informatica?
What is Data Caches size?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How do you set a varible in incremental aggregation
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
what is the Default Source Option For Update Strategy Transformation?