top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

data migration in informatica

+2 votes
332 views

A large amount of data is coming from source to target. After a successful insertion in target, we have to change the status to every rows as "committed". But when will we know that all datas have come or not in target without directly querying the source?

For example - suppose 10 records have migrated to target from source. We cannot change the status of all the records as "committed" before successful insertion of all records in target.

So before changing the status of all the records, how will we know that 11th record is coming or not? Is there anything that will give me the information about total records in source?

I need a real-time based answer.

posted Jun 13, 2014 by Sunil

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button
What is the source? Are we talking about a real-time session? Usually you could just use Post-SQL to execute update statement
commented Jun 16, 2014 by Shweta Singh

Similar Questions
0 votes
Workflow migration: retain persistent values?

When I migrate workflows from Development repository to Production repository, there is a chekc box "Retain persistent mapping variable values.." in migration wizard. What happens if I check this box? Does it keep e.g. values in the production environment or does it replace these values from the Development repository?

+1 vote
What are various ways in which we can perform data quality checks in informatica Big data edition?

What are various ways in which we can perform data quality checks in informatica Big data edition. We need to perform data quality checks in 100's of columns; most basics checks are data format check or number check etc. etc.

+1 vote
Text file location and its data check at FTP server in informatica

How to check in informatica whether a flat file exists at a location at FTP server and to check if it has some data in it?

+1 vote
Changing data source connection at runtime in an Informatica workflow

I have a mapping which I need to be able to run against multiple source schemas (having the same structure), one schema at-a-time. Given the number of schemas, I would rather not set up a session for each schema in order to specify a particular mapping connection, as that will require new sessions to be added as new schemas are added.

Is it possible to set up a workflow in such a way that the data source connection for a mapping within a session is defined (or passed in as a parameter of some sort) at run-time?

...