What will happen if one column mentioned as primary key in DB and other column as primary key in mapping structure in informatica Powercenter or IICS.
What will happen if one column mentioned as primary key in DB and other column as primary key in mapping structure in infomratica
280 Views Asked by sami phani At
1
There are 1 best solutions below
Related Questions in INFORMATICA
- PWX-00001 Error opening repository "dtlmsg.txt". RCs = 268/150/2
- Expression to replicate Aggregator
- rep_1235 this object has been modified since the time it was read
- Converting LONG to CLOB in INFORMATICA
- jar file execution through informatica java trasformation
- i have headers separately, how to import it to informatica target
- Shell Script to Validate Filename
- How to perform binary data comparison in Informatica Power Center
- using http link in informatica power center
- Executing PMCMD command from JAVA Client
- Excel Macros on Informatica
- Is there a way to avoid the target table in informatica (powercenter)?
- Getting Special character only in the "first column of first row" while loading to a text file using informatica
- how to add new line between header and data in flat file using informatica?
- ETL tool migration : Best Practices in Parallel Run
Related Questions in INFORMATICA-POWERCENTER
- PWX-00001 Error opening repository "dtlmsg.txt". RCs = 268/150/2
- Number of records using normal joiner in informatica
- jar file execution through informatica java trasformation
- •Informatica powercentre target xsd assistance
- How to perform binary data comparison in Informatica Power Center
- using http link in informatica power center
- Executing PMCMD command from JAVA Client
- Command-line Powercenter test tool
- ETL tool migration : Best Practices in Parallel Run
- Default join type in lookup transformation?
- Informatica Powercenter data truncation/overflow error
- Get max value of a column in my source table in Informatica
- Informatica: Delete rows from multiple tables sequentially. Then Insert
- Informatica shift field values to right
- what is difference between creating & running the workflow in client and server?
Related Questions in INFORMATICA-CLOUD
- Informatica sorter transformation performance tunning related to cache allocation
- Informatica Cloud Target file column order
- to find the highest sal employees and add only those employess in target by using IICS or informatica
- Upload file to s3 browser through batch script
- Consume data from wsdl and expose the data as Rest or soap through Informatica cloud to be consumed by Salesforce application
- Informatica relational connection password change
- How to process salesforce error files in informatica cloud
- What will happen if one column mentioned as primary key in DB and other column as primary key in mapping structure in infomratica
- Need to convert the double data type precision of scale 1 to 2 in informatica cloud expression transformation
- make source and target to be sync in informatica
- How to I execute part of a daily workflow only on Sundays
- Databricks and Informatica Delta Lake connector spark configuration
- SQL Works in SQL Developer but not in Informatica Cloud (IICS)
- I want to convert json format data in java object in Java transformation
- Remove leading space in time stamp in Windows
Related Questions in INFORMATICA-DATA-INTEGRATION-HUB
- to find the highest sal employees and add only those employess in target by using IICS or informatica
- What will happen if one column mentioned as primary key in DB and other column as primary key in mapping structure in infomratica
- How to I execute part of a daily workflow only on Sundays
- I want to convert json format data in java object in Java transformation
- How can we use advanced date filter(SYSDATE) in Source while reading the data in informatica iics?
- query to retrieve workflow details from repository tables in informatica?
- Informatica: How to make a condition for two tables joining execution
- How to map specific record type from source to specific record type in target
- How to convert flat file DateTime to Timestamp format in Informatica Cloud Services
- getting error as "Failed to find user name [WORKGROUP\SYSTEM]" during informatica installation
- How to use decode in IICS when field data contain single quote?
- Informatica. I have workflow with 5 sessions. How to limit no of rows for each session and in second run how to pick the different records?
- How to use Parser Transformation for JSON data in IICS?
- Oracle replace and translate command in IICS
- how to compare column names and order of columns in two files in informatica cloud
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
It would not create an issue, as long as it is for reading the data.
But, if we are going to write the data in the target(using different keys) then Informatica would perform the record operation(I/U/D) on the basis of the key defined in Informatica.