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
- 10413 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 |
disable caching in a lookup transformation?
can you please explain me pre session and post session options?
Explain informatica architecture - version 8 / 9
what is a time dimension? give an example?
can session assigned multiple mappings or not?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
During the running session, output files are created by informatica server. Enlist few of them.
what is dimension table?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
What is the different lookup cache(s)?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
I have a flat file, want to reverse the contents of the flat file
Teradata 
