top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

INFA SFDC Connector refresh staging table

0 votes
184 views

I have a problem in INFA where the metadata definitions from source/target tables gets out of sync with the actual definition in the underlying database. I'm working with SFDC connector in INFA, and the SFDC object is changed my integration fails. Is it possible to script to update my source/target table metadata before processing?

posted Jul 23, 2014 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

No, this is not possible, I'm afraid. This would require to also refresh mappings and session. By design, Informatica Source/Target definitions are not related with any particular implementation. This might cause a lot of issues if you'd use one mapping in multiple session to access many different servers. If one of them would change, this would impact every other one.

I guess you can have some additional session that would perform simple read operation to make sure the structure has not been modified before actually starting the main ETL part.

Well, to be honest: other solution would be to have a tool that checks source and target definition, generates the whole mapping/session/workflow, does the import operation on repository with conflict resolution and runs the workflow afterwards. This is possible, but... very complex.

answer Jul 24, 2014 by Shweta Singh
Similar Questions
0 votes
Trigger Infa workflow based on the status column in oracle table

Hi All,

I want to implement the below scenaio without using pl/sql procedure or unix script. I want to be implement by using Pwoercenter only.

Kinly suggest me.

1.I have a table called emp_details with coulmns (empno,ename,salary,emp_status,flag,date1) .

2.if someones updates the columns emp_status='abc' and flag='y' ,Informatica WF 1 would be in contunous running status and checking emp_status value "ABC"

3.If it found record / records then query all the records and it will invoke WF 2.

  1. WF 1 will pass value ename,salary,Date1 to WF 2 (Wf2 will populate will insert the records into the table emp_details2).

Kindly tell me the informatica approach instead of plsql and shell script...

Thank you

+1 vote
Trigger Infa workflow based on the status column in oracle table

I want to implement the below scenario without using pl/sql procedure or unix script. I want to be implement by using Powercenter only.

Kindly suggest me.

  1. I have a table called emp_details with columns (empno,ename,salary,emp_status,flag,date1) .
  2. If someones updates the columns emp_status='abc' and flag='y' , Informatica WF 1 would be in continuous running status and checking emp_status value "ABC"
  3. If it found record / records then query all the records and it will invoke WF 2.

  4. WF 1 will pass value ename,salary,Date1 to WF 2 (Wf2 will populate will insert the records into the table emp_details2).

    Kindly tell me the informatica approach instead of plsql and shell script...

+1 vote
Extraction of data from Siebel Data base to Dat file and staging table

I am working on a new requirment and I am new into this. So seeking your help. Requriment - From Siebel base tables (S_ORG_EXT,S_CONTACT,S_PROD_INT) I have to export data and need to put into two staging tables (S1 and S2) and from these staging tables I need to create dat files pipe delimited that include row count also. For staging table S1, we should have Accounts with their associated contacts and for S2, we should have account with its associated contact and Product.

How should I need to go about this. Should I need to use Informatica job directly to pull data from Siebel base tables or need to run EIM export job to get data in EIM table and from there to staging table.

Kindly help me know which way I should go.

0 votes
Automate refresh and saving of Excel Power Pivot

have seen a few threads on here and other sites which offer bits of a solution to what i'm trying to do, but struggling to bring it all together in one nice package. As part of a (at least once a day) daily data load, an Excel 2013 Power Pivot report is used as a look up to identify missing data, I'm looking to automate the following:
•Open Excel file and refresh data
•save a copy as a csv file

I've been playing with using a windows batch command to open the file (so I can then use this .bat file in an Informatica Workflow). I've then set the data connections to refresh on open, but now struggling with saving to a CSV file. Have been playing with some VBA examples but haven't been able to get anything to work so far - I'm new to VBA and most of the examples i've found have extra bits in them for displaying messages and checking for existing files, but i dont the code well enough to be able to pick these lines out.

Looking for some advise firstly on whether what i'm trying is a viable approach, and then if it is what do I need to do differently (paticularly with the VBA). If it's not a good approach, then what should i consider?

thanks in advance!

0 votes
Informatica Connector

Is it Possible to write a Streaming API Connector and publish in Informatica? If Possible can use it to trigger any WorkFlow in Informatica. Please add Code Snippets if Possible. Thanks in Advance.

...