• Home
  • Mahendra Rajpoot Answers

Answered Questions

  • Sep 11 2014
    07:01 AM
    7228
    12

    Maintaining Data Integrity
    • abhiastra

    How can I maintain unique surrogate key if 2 separate workflow in different repository run at the same time and insert/update the main table. Please let me know how can I achieve the above scenario.

    Venkateswara Rao

    • Oct 14th, 2014

    In this scenario the best approach is to define a sequence in Database (ex :oracle ).. Call in informatica when ever you want . even if it is across multiple repositories it will work.

  • Sep 12 2012
    12:57 PM
    19582
    15

    In scd type2
    • kalyanraghava

    Is it possible to use SCD Type-2 without using Lookup in the mapping?If it is possible please let me know. How it will be possible?

    ashwin

    • Mar 22nd, 2017

    SRC-->SQ--> JNR-->EXP-->RTR-->TGT(Insert for both new and updated records) SRC(TGT)-->SQ--> -->TGT(Update The entire implementation will be same as that using a l...

    ashwin

    • Mar 22nd, 2017

    The entire implementation will be same as that using a lookup. The only thing we need to replace the Lookup transformation with a Joiner transformation. In the Joiner transformation the Source table w...

  • Aug 03 2012
    07:15 AM
    8057
    6

    what is staging are why we need it
    • kishore sai

    MAHESH MANAM

    • Aug 16th, 2012

    It is a automated process of building a data warehouse which involves taking the data from disparate source systems, converting them into a consistent form that can be loaded into the warehouse and pe...

  • May 26 2012
    05:32 PM
    10580
    6

    How we can validate all mapping at a time?
    • Ramesh12888

    We can validate all mappings in PowerCenter Repository Manager window by each folder.

    lakshmi

    • May 27th, 2012

    in repository go to menu tool then queries.query browser dialog box will appear.then click on new button. in query editor,choose folder name and object type after that execute it(by clicking the blue...

  • Nov 07 2006
    12:14 PM
    28695
    60

    Could any one please help in finding the solution for this workflow related question.

    • Thiyagarajan

    Suppose I have one source which is linked into 3 targets.When the workflow runs for the first time only the first target should be populated and the rest two(second and last) should not be populated.When the workflow runs for the second time only the second target should be populated and the rest two(first and last) should not be populated.When the workflow runs for the third time only the third target...

    sum

    • Oct 8th, 2015

    Define one variable $$CNT in mapping and assign its initial value as 1 in parameter file Take an expression and do below coding count =$$CNT INC_COUNT=$$CNT+1 O_INC_CNT=SETVARIABLE($$CNT,INC_COUNT) Ad...

    Rakesh

    • Feb 9th, 2015

    your above logic is perfect..but instead resting the variable at workflow level you can add these condition in first router group => MOD(o_Flag,3) = 1 2nd router group =>MOD(o_Flag,3) = 2 3rd router g...

  • Sep 21 2004
    04:00 AM
    22127
    34

    In which condtions we can not use joiner transformation(Limitaions of joiner transformation)?

    Both pipelines begin with the same original data source. Both input pipelines originate from the same Source Qualifier transformation. Both input pipelines originate from the same Normalizer transformation. Both input pipelines originate from the same Joiner transformation. Either input pipelines contains an Update Strategy transformation. Either input pipelines contains a connected or unconnected...

    Tejas

    • Jun 7th, 2019

    We cannot use Update strategy in a pipeline when using joiner condition, because update strategy has property i.e treat row as which has insert,update,delete, which are processed at runtime, this limit joiner transformation to know exact properties values till runtime, and then proceed further.