performance wise which one is better in joiner and lookup
transformation
Answers were Sorted based on User's Feedback
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
How to delete duplicate records in a flat file source?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
can session assigned multiple mappings or not?
What is the difference between router and filter?
Discuss the advantages & Disadvantages of star & snowflake schema?
what is mapping parameter and mapping variables
How to delete first 3 rows & last 3 rows in target table in informatica
Explain the flow of data in Iinformatica?