Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
3 16339I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
4 6925WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
1 4206If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
1 6041Post New Informatica Questions
What is session task and command task?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Enlist few areas or real-time situations where informatica is required.
tell me about your project functionality
what is diff b/t sorter t/r and agg have the option sorter property...
What does command task mean?
explain abt ur project architecture?
How to create or import flat file definition in to the warehouse designer?
Explain about Informatica server process that how it works relates to mapping variables?
Whats there in global repository
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is sorter transformation?
What do you mean incremental aggregation?
Define filter transformation?