Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10420 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
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?
COM components can be used in Informatica
Make a note of the quantity vaults made in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Where do we use mapping variables in informatica?
Why update strategy and union transformations are active? Explain with examples.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the different clients of powercenter?
expain about the tune parameters?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the static cache and dynamic cache in informatica?
What is informatica?
What are the measure objects?
How do we call shell scripts from informatica?
How union transformation is used?
