Wednesday, May 29, 2013

Scenario 1

We have a source table as follows:

We have to move the into the target tables such that one

MY SOURCE      MY TARGET
SNo Name
1 A
2 B
1 C
3 D
4 F
1 E
2 G
SNo Name
1 A
2 B
1 C
3 D
4 F
1 E
2 G

After importing Source and Target, create a Sorter transformation to sort the data.
Then create an Expression transformation with 3 ports named say v_Name, v_SNo (2 variable ports) and o_Name (output port).
Give an expression as follows
v_Name -> IIF(SNo = v_SNo, v_Name||Name, Name)
v_SNO -> SNo
o_Name -> v_Name
Finally connect the ports to Target, create and execute the session and workflow.

6 comments:

  1. I am doing research for a class and I need to learn more about power centers. Can someone guide me in the right direction to understand power centers better? What purpose do power centers serve? How much do they cost to build?


    bryanflake1984| http://www.elginindustries.com/solution/industrial_equipment_products/electrical_products_for_mining/power_centers.aspx

    ReplyDelete
  2. Hi,

    I have some questions about PowerCenter Express, and I ask for help, if you can and have time for it:

    1) Update strategy:

    I want to make a typical uptaing process in wich I have a database table with a PK: var1,var2,var3.
    If a row of my datastraem have a key var1-var2-var3 that is actually in the table I want to update it, if noy I want to insert.
    What expression sintax do iI have to use?
    iif( var1-var2-var2 exists......, DD_UPDATE, DD_INSERT)

    I have tried several options, but I don' get the right sintax. It may be simple, help please!!

    2) Logs

    I am chanching the log level in a workflow, but It doesn't have effect.

    I chanhe: info -> trace -> debug -> error

    but in the log I get by:

    infacmd.bat wfs startworkflow -dn Domain_localhost -sn DIS -un Administrator -pd Administrator -sdn Native -a Application_name -wf workflow_name > output.log

    It doesn't change....... any idea?, any hepl?


    3) Loops:

    How do I make a loop in a workflow??

    I want to execute a mapping for all the periods in a range of periodos. That is period from 201401 to 201412.
    Do I have to put the condition in a door link and change the var value in a attribution taks?


    4) vars from workflow to mapping

    How can I use a var defined in a workflow in a mapping?
    The var period from the former question. I define it in a workflow, but I need to use in a mapping.

    Thanks in advance for your help.

    Juan

    ReplyDelete
  3. Very nicely Explained....Check this site to learn more about Informatica Power Center..

    http://tekclasses.in/course/informatica-training/

    ReplyDelete
  4. thanks for shared wonderful information of giving best information.its more useful and more helpful. great doing keep sharing
    Informatica Training in Chennai

    ReplyDelete
  5. That's an incredibly useful post. Thanks alot for your afforts. I would be glad If you get time to read my article. Thanks in advance
    informatica online training
    informatica training

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...