Are there any types of Dynamic Caches in informatica
Answers were Sorted based on User's Feedback
Answer / hai
dynamic cache is there. LKP dynamic cache...........
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / pa1
Dynamic Cache is there for look up t/r. But we need to look
up only on targets
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / maheedhar
I have answered no,kindly correct if am wrong
| Is This Answer Correct ? | 2 Yes | 12 No |
what is the difference between onsite & client site?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
What is standalone command task?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
Using Expression transformation how to remove duplicate records from a relational source?
Issue with Update override at Target table in Informatica.
What is a connected transformation?
In a sequential batch can u run the session if previous session fails?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario