While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?
Answers were Sorted based on User's Feedback
Answer / kish`
hi,
update strategy never use for flatfiles....plz correct me,
if it is wrong
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / krish
flat file
bcz no connections needed no network busy etc;
| Is This Answer Correct ? | 0 Yes | 5 No |
Why we select the table which has minimum number of records as Master table in joiner?
Write the program through which the records can be updated?
Differentiate between router and filter transformation?
Can you start a session inside a batch individually?
How to eliminate duplicates from flat file..what is the procedure
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
What did you do in source pre load stored procedure
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?