Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15279 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
duplicate records can be eliminated the following ways:
1) by using select distinct option
2) by over riding sql with group by port on the column
which gets duplicate values ( P_key column)
3) by connecting the source to an expression transformation
and flagging the duplicate records to another target by
writing an expression in the exp editor
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is different between sequential batch and concurrent batch and which is recommended and why?
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.
how do u extract data from different data sources explain with an example?
what is the difference steps for data modeling?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Can we create Hierarchies in generic datasources?
What is cube grouping?
What are three tier systems in etl?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
how to load the data to fact table?
Explain the use lookup tables and Aggregate tables?
Mention few test cases and explain them?
Explain about hash partitioning?
Explain do we need an etl tool? When do we go for the tools in the market?
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.
