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
- 9700 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
how we can load rejected record's at run time?(not through bad files)
Mention a few design and development best practices for informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is pmcmd command?
What are the different types of repositories created using informatica?
What are active and passive transformations?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is informatica metadata and where is it stored?
Explain what are the different versions of informatica?
what is the difference between informatica6.1 and infomatica7.1
where to store informatica rejected data?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
