Answer Posted / siva
There is no meaning for 4 in Update Strategy.
0 Insert
1 Update
2 Delete
3 Reject
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How to generate sequence numbers using expression transformation?
What is exclusive and normal mode for repository services?
What is domain and gateway node?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to create a non-reusable instance of reusable transformations?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Have you worked with/created Parameter file
what is the size of your data warehousing?
What is the meaning of decode in informatica?
Explain the types of transformations?
What is intricate mapping?
How are the sources and targets definitions imported in informatica designer?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?