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
- 10545 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raju4dw
U CAN GO FOR SESSION RECOVERY
THEN IT WILL LOADS ONLY REMAING RECORDS INSTEAD OF ALL
RECORDS.
RAJENDRA
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Answer / pradeep
1)Alternative to updated strategy,we can with target update override. US works based primaray key constrainst where as target updated override works without primary key constraints.
2)When you configure session with Normal load,the integration service performs record by record as a result IS can capture commit points and it enables the session recovery.
The IS capture commits points from database log and saves in repository
3) The lookup transformation genrates the sql qurey,query contains select,group by,order by.we can override default query by specifying the order by clause
| Is This Answer Correct ? | 1 Yes | 0 No |
How to extract sap data using informatica? What is abap? What are idocs?
create a mapping to retrieve the employees who are getting salary greater than average salary?
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
What is option by which we can run all the sessions in a batch simultaneously?
What did you do in source pre load stored procedure
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
Explain the different lookup methods used in informatica?
what is dynamic cashe
how to convert the .doc docs into .txt format using informatica
Define filter transformation?
when we dont use aggregator in mapping ?
Teradata 
