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
- 3 Answers
- 9843 Views
- IBM, I also Faced
- E-Mail Answers
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
Which are the different editions of informatica powercenter that are available?
State the differences between sql override and lookup override?
What is the maplet?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What do think which one is the better joiner or look up?
What are active and passive transformations?
Explain lookup transformation in informatica
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How you know when to use a static cache and dynamic cache in lookup transformation?
What is confirmed fact in dataware housing?
differences between service based and product based?
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 are the advantages of informatica?
can anyone explain me about retail domain project in informatica?
