How three column in one table concatenated in Informatica?When i am giving SAL || COMM || DEPTNO in exp it's failed to read during testing.By giving (CONCAT(CONCAT(SAL,COMM),DEPTNO)) i am also getting
Latest Answer: emp_first_name |' '|emp_middle_name|' '|emp_last_name ...
How to connect Informatica's with SAP R/3?
Latest Answer: It is due to wrong server connection, try to assign server correctly because the IP address what you are using may change, so try to resolve IP address in work flow manager -> assign server configuration. ...
Hi, I am new to Informatica just trying to do some mappings. I tried to do SCD type 1. after loading source tables I used expression transformation to do some formatting and then I used Router Transformation.
Latest Answer: All the Above answers are wright, just create port in group and name it as update if you want to update, by default a port is created, now just map into corresponding router trans from update transThanksBabu Shiv ...
What is the difference between SQL Override and Lookup Override
Latest Answer: Obviously we have some differences between those 2 Overrides...1. SQL Override is to limit the number of incoming rows entering the mapping pipeline Lookup Override is to limit the number of lookup rows to avoid the whole table scan ...
Hi all,I would like to know what are the key differences between PowerCenter 7 vs 8? Give one significant change version 8 is offering?
Latest Answer: I have worked with Informatica 7.1 but haven't used versioning.Informatica 8 is surely bundled with versioning systemAlso adding headers in a text target file is also possible in Info-8 without specifying the same while installation (which is wat ...
How to join two flat file and load the data in target using Joiner, Lookup, Source Qualifier.
Latest Answer: The only way to join two flat file is joiner transformation,if the structure of the two flat file is same and the datatypes also matches we can use union transformation, but it wont join the flat files, it will merge the flat flies. In informatica the ...
How to connect MySQL Database to Informatica PowerCenter
How to write custom transformation?
What do you mean by Checksum and Pipeline in Informatica? Where do you use it ?
Latest Answer: Pipeline in information means a series of transformation starting from one set of sources to a target set of targets. ...
How many Dimension tables can connect to a Fact table?
Latest Answer: The number of Dimensions depends primarily on the requirement. I have built systems with a few FOUR Dimensions on a Fact and as many as TWENTY. There is no physical limit imposed by either the database or ETL tool.Kimball recommends however, ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
