1) Alternative to update strategy transformation
2) out of 1000 records after loading 200 records, the
session got failed. how do u load the rest of records ??
3) use of lookup override
Answer Posted / mike
1)YOu can update the target table by using target update
override. I think this might be the alternative
2)consider performance recovery
3)lookup override is nothing but overriding the default sql
which is generated by the lookup at run time. the default
sql contains select,groupby and orderby clauses. The
orderby clause orders the data based on the ports in lookup
tab. If you want to change the order then we need to
mention two hyphens at the end of the sql, which means the
query generated by the informatica server is commented.
correct me if i was wrong
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Why filter transformation is an active one?
server hot-ws270 is connect to Repository B. What does it mean?
What is the maplet?
what are 3 tech challenges/ common issues you face?
What do you understand by SOA of Informatica?
What are the restrictions of union transformation?
What is the command used to run a batch?
How you can differentiate between connected lookup and unconnected lookup?
What is the difference between informatics 7x and 8x and what is latest version?
Differentiate between Load Manager and DTM?
Is there any target staging area in informatica not staging area
What is the function of union transformation?
How to handle decimal places while importing a flatfile into informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are roles and groups and benefits of using them?