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
- 10591 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 |
what is degenerated dimension
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
Design a mapping to load the cumulative sum of salaries of employees into target table?
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
Can you copy the session to a different folder or repository?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
What are the new features of informatica 9.x in developer level?
Issue with Update override at Target table in Informatica.
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
Teradata 
