What is the difference between SQL override in Source Qualifier and SQL override in Look up transformation.
Latest Answer: using :TuTargetupdate override. ...
How do you migrate from one environment to another like development to production in Informatica. Which files do you move?
Latest Answer: We can add header and footer record in two ways.1) Within the informatica session we can sequence the data as such that the header flows in first and footer flows in last. This only holds true when you have the header and footer the same format as ...
Latest Answer: There are several errors you will get. Couple of them are1. if informatica failed to connect data base2. If source file not eixsts in location3. If paramerters not initilized with parameter file4. incompataible piped data types etc. ...
How can we delete duplicate rows from your source in mapping without using SELECT DISTINCT option in source qualifier?
What happens when the session stops half way while loading? How to join a flat file without matching keys in RDBMS?
I have multiple servers, I want to assign a work flow to multiple servers
Latest Answer: Informatica server will use Load manager process to run the workflow,load manager will do assign the workflow process to the multiple servers. ...
Latest Answer: Hi:Trigger can not be called from Stored procedure. Trigger will execute implicitly when u are performing DML operation on the table or view(instead of views).U can get the difference between trigger and sp anywhere in the doc.Hanu. ...
What is source based commit and target based commit with an example ? What is the background process that wil be done if you select source based commit or target based commit ?
View page << Previous 8 9 10 11 [12] 13 14 15 16 17 Next >>
Go Top
