performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Answer Posted / soujanya
before cache joiner after cache lookup
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
I have a flat file, want to reverse the contents of the flat file
Which files are created during the session rums by informatics server?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
where to store informatica rejected data?
How can one identify whether mapping is correct or not without connecting session?
Name the different lookup cache(s)?
What is enterprise data warehousing?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is the commit type if you have a transaction control transformation in the mapping?
What are the informatica performance improvement tips
What is xml source qualifier transformation in informatica?
How does a rank transform differ from aggregator transform functions max and min?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Separate from a database, an information bazaar, and an information stockroom?
How we can use union transformation?