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
Answer Posted / 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 |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Is stop and abort are same in informatica?
Explain the types of lookup transformation?
What is the difference between Active and Passive transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Why is sorter an active transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
define galaxy repository in informatica
How to join three sources using joiner?
What is informatica? Why do we need it?
Is there any way to read the ms excel datas directly into informatica?
What is target designer and target load order?
What is a difference between complete, stop and abort?
How can we use batches?