what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy
Answers were Sorted based on User's Feedback
Answer / vikas
Update Strategy Works on Tables and not on files. In session, Treat source rows should be data driven.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abhinaw prakash
For update strategy t/r we should have Constraints defined
on the table.
Else we'll have to use Update override property in session
properties.
Delete in session property we use for deleting a record
based on condition were as truncate is for removing the
previous record from the table before inserting new set of
data.
| Is This Answer Correct ? | 1 Yes | 2 No |
what is polling?
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
How to display First letter of Names in Caps?
8.what is mapplet ?give example?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
What are the new features of informatica 7.1?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
What are the new features of informatica 9.x at the developer level?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?