Interested to Buy Any Domain ? << Click Here >> for more details...
without dynamic lookup transformation how to insert new
rows and update existing rows?
- 7 Answers
- 16249 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / murali raju
Simple you can take one look up transformation give the
condition as empno=empno1(if it is primary key) and take
update strategy transformation just pass condition as
IIF(empno=empno1,dd_update,dd_insert). in this way we can
insert new records and update old records without keepimg
historical data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different transaction levels available in transaction control transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Differentiate between source qualifier and filter transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is a predefined event?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
4 yrs etl devloper roles and responsibilities?any body give solutions
Clarify the utilization of aggregator cache record?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to load the data from a flat file into the target where the source flat file name changes daily?
Plz can any one say me how to get the informatica certification materials and dumps
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Differentiate between a database and data warehouse?
