IICS | Load DUPLICATE and UNIQUE records in Different Tables in Informatica Cloud

preview_player
Показать описание
Hi Friends , in this video we will learn how to load duplicate and unique records from source (any type of source ) to different target tables:

Please check out below videos on how to create Mapping Task :

Please check out below videos on how to create Taskflow :

#informatica #iics #informática #tutorial #etltesting #datawarehouse #sql
  1. ETLSTATION
  2. powercenter
  3. informatica
  4. iics
  5. cloud
  6. orcale
Рекомендации по теме
IICS | Load 0:16:33

IICS | Load DUPLICATE and UNIQUE records in Different Tables in Informatica Cloud

In IICS How 0:14:09

In IICS How to Load Duplicate Records to one target and Unique records to another Target

IICS | Separating 0:13:50

IICS | Separating Unqiue and Duplicate and load into each Target #informatica #tamil

how to load 0:09:11

how to load unique and duplicate records in IICS | 28

IICS | Best 0:15:22

IICS | Best Method To Remove Duplicates Records From Source in Informatica Cloud

Informatica/IICS scenario: Load 0:20:00

Informatica/IICS scenario: Load unique records in one table and duplicate records in another table

How to remove 0:08:03

How to remove duplicate data from source using IICS

IICS | Remove 0:45:32

IICS | Remove Duplicates From FlatFile in Informatica Cloud

Zero To Hero 0:39:20

Zero To Hero - IICS || DAY-4 || Hierarchical Schema, XML, JSON File Load/Read to Oracle SQL

Informatica(IICS) :- Mapping 0:05:43

Informatica(IICS) :- Mapping to remove duplicate records from flat file

IICS | Dynamic 0:34:45

IICS | Dynamic Lookup in Informatica Cloud and Remove Duplicate , Shared Cache ,Persistent Cache

duplicate and unique 0:27:22

duplicate and unique loading using IICS

IICS PRACTICAL SESSION 0:19:48

IICS PRACTICAL SESSION 5. Router Transformation- Load data countrywise, Duplicate Name concat.

Informatica(IICS) :- Mapping 0:06:43

Informatica(IICS) :- Mapping to load Even and Odd records in different tables

IICS | Remove 0:23:45

IICS | Remove Duplicates in Snowflake Using ROW_NUMBER in Informatica Cloud

IICS | Remove 0:18:52

IICS | Remove Duplicates in Oracle Using ROWID in Informatica Cloud

IICS | Cleanse 0:08:35

IICS | Cleanse Transformation (Data Quality/Data Integration) | #informatica

IICS | Incremental 0:09:31

IICS | Incremental data load - simplified version | #informatica

IICS | Load 0:17:00

IICS | Load data from 3 Different Databases without Joiner in Informatica Cloud |Same Structure

IICS | Incremental 0:34:01

IICS | Incremental Load Using System Variable in Informatica Cloud

IICS | Incremental 0:35:50

IICS | Incremental load using Timestamp Passed by Parameter File in Informatica Cloud

IICS | Load 0:15:30

IICS | Load ODD & EVEN Records in Different Target in Informatica Cloud |Relational |Flatfile

Find Distinct & 0:00:54

Find Distinct & Duplicate record? #sql #etl #iics #education

IICS | Parse 0:38:19

IICS | Parse XML File and Load into SnowFlake Database in Informatica Cloud

Комментарии
Автор

Hi Roshan,
This is one of the easiest methods I have seen. Awesome. Thanks for sharing it

SubhashiniSundaresan-pt
Автор

Hello Roshan, I told the same way when I was asked this question in an Interview .. but Interviewer asked me 2 more approaches of doing the same which I am not sure.

acceleratoronly
Автор

Hello Roshan, Your videos are really helpful. Could you please help me with How to archive used files in AWS S3 using CDI?. and could you please make video on AWS S3 like multiple file loadng, Archiving and File MAnagement that will be very helpful. Thanks for the great tutorials

temporary
Автор

Internal error. The DTM process terminated unexpectedly. Contact Informatica Global Customer Support. I am getting this error when I was loading in snowflake tgt tables. How to resolve?

dakshssarapuregamingandpia