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 17623I 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 8386WE 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 4876If 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 6905Post New Informatica Questions
How to join three sources using joiner? Explain though mapping flow.
What are the popular informatica products?
Performance tuning( what you did in performance tuning)
What is the Process to creating lookup transformation in informatica
How to elaborate tracing level?
Mention few advantages of router transformation over filter transformation.
COM components can be used in Informatica
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
what is SDLC way of code development?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How can we use mapping variables in informatica? Where do we use them?
Explain what are the different versions of informatica?
what are the Methods For Creating Reusable Transformations?
What is difference between a gateway node and worker node?
How do you load only null records into target?