in mapping level we have update strategy in that we have DD-update and at session level we have DD_insert when we run mapping what will happen is it inserted or updated?
Latest Answer: As per my openion it will insert only because it give preference to session ...
We have one source and 3 targets with same fields i.e empno,ename in all 3 targets and source, then the 1st row in source should go to 1st target, 2nd row in source should go to 2nd target and the 3rd
Latest Answer: First Load Data from source To One dummy table in target with SEQ Gen T/R.in SEQ Gen T/R Set min value 1 and max value 3 and check the reset option.It will load the data with new column Values 1,2,3,1,2,3...........Then use that dummy table as a source ...
Latest Answer: when u enable the incremental aggregation ,it passes all the source rows to the mapping and uses the historical cache to perform the aggregate calculations ...
Hi,I am just wondering if there is a direct way to load Excel file into database using Informatica without having to convert Excel to .CSV or XML format. Because we may have to load data from different
Latest Answer: convert excel file to .csv and then csv to text file...then u can take the source as flatfile.. ...
I am unable to connect to the repository server in repository administrator console after registering new server
Latest Answer: Hi,SOGOTO SERVICES BYRUN-->TYPE( SERVICES.MSC)START THE INFORMATICA SERVER AND NOW CONNECT IN REPOSITORY SERVER ADMIN CONSOLEOR CHECK THE PAASWORD THAT U HAVE GIVEN FOR REP SERVER ...
which is primary server process in informatica?1.repository manager 2.load manager 3.workflow manager 4.workflow designer
Latest Answer: hi.."load manager' is the primary process of informatica power center server"DTM-data transformation manager" is the secondary prcess..go through the architecture of informatica power center server..thank u...suvashis ...
Latest Answer: ODBC is the database drivers which is used to connect from clinet to the relational database.DSN is the data service name which is thename of the odbc name give by the customer inoreder to access from the clientNative Drivers is the drivers ...
Latest Answer: My dear we can use more than two group in router transformation. it is the main purpose of router to define many condition. there is one default output also so if you are giving 4 condition there than output will be 5. and for this we need 5 target.hope ...
Why cant we use a sequence generator or update strategy transformation before a joiner or union transformation?
Latest Answer: Execution of this query will give an error.We will get error in this Case as the the out put for table 1 is a string where as the the return of table 2 is a number and both are of different datatype. ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
