In SCD Type 2 Mapping, I Have 50 Records. How to compare without going record by record?

DEEKSHA

• Mar 12th, 2019

Use joiner transformation, instead of lookup to target table.

Arpit Gautam

• Nov 1st, 2018

Use MD5 check constraint in Expression transformer

Answer Question  Select Best Answer

Both pipelines begin with the same original data source. Both input pipelines originate from the same Source Qualifier transformation. Both input pipelines originate from the same Normalizer transformation. Both input pipelines originate from the same Joiner transformation. Either input pipelines contains an Update Strategy transformation. Either input pipelines contains a connected or unconnected...

Tejas

• Jun 7th, 2019

We cannot use Update strategy in a pipeline when using joiner condition, because update strategy has property i.e treat row as which has insert,update,delete, which are processed at runtime, this limit joiner transformation to know exact properties values till runtime, and then proceed further.

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

We cannot use Joiner t/r immediately after sequence generator and upd strategy t/r as 1. Joiner will join 2 sources and it cannot join 3rd source as seq generator. Also if we select seq generator as 1...

Answer Question  Select Best Answer

Could not execute action...

The Service Name_repository could not be enabled due to the following error: OBJM_54538 - Unable to connect to the repository Name_repository on database mailto:DESKTOP-4FVDDK@IPC.error: OBJM_54538

Please could you help me with this issue?

Why we use joiner transformation to update records in a flatfiles?

Sanket Kamble

• Oct 15th, 2020

Flat file cannot be updated but it is always overwritten

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: srinvas vadlakonda

• Sep 28th, 2006

---

Source name
Database location
Column names
Datatypes
Key constraints

srikanth

• May 11th, 2022

Column names

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Jun 12th, 2009

ODBC data source, username, owner name, password. Once the connection is established, select the table.

Improve Answer

I have 2 workflows named as W1 and W2 so I need to execute W2 but after W1 workflow executed successfully then only executed W2 workflow? How to do this one?

Venkat

• Dec 22nd, 2022

We can trigger W2 after completion of W1 by using pmcmd commands in shell scripting.

Pranav

• Apr 25th, 2019

Can we not use worklet to add two workflows and link them to run one after the another ?

Answer Question  Select Best Answer

How can we do incremental loading if the source is flat file?

Jacqueline

• Aug 23rd, 2023

Ratnesh, your answer is fine if we know what the natural keys are but what happens if the file is extremely large and you have no idea what the keys are in the flat file? If that is the case then I ...

Ratnesh

• Dec 31st, 2020

If your source flat file is always full file , based on the natural keys, you can identify the records by lookup on the target table , whether records are existing or new. If records are new, go ahead...

Answer Question  Select Best Answer

Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregation. what is the order that we have to group by?Thanks,Arpita.

Kevin

• Jul 19th, 2023

Database partitioning. The PowerCenter Integration Service queries the IBM DB2 or Oracle system for table partition information. It reads partitioned data from the corresponding nodes in the database....

rajesh_kare

 Profile Answers by rajesh_kare Questions by rajesh_kare

• Oct 21st, 2010

You can define following partition types in workflow manager.1) Database PartitioningThe Integration Service queries the IBM DB2 or Oracle system for table partition information. It reads partitioned ...

Answer Question  Select Best Answer