We have to move the into the target tables such that one
| MY SOURCE | MY TARGET | |||||||||||||||||||||||||||||||||||
|
|
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.
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?
ReplyDeletebryanflake1984| http://www.elginindustries.com/solution/industrial_equipment_products/electrical_products_for_mining/power_centers.aspx
I have to write a paper about power centers and what they do. Would you be able to give me more information about the topic? If not, could you please offer me a few resources that I should look at? http://www.elginindustries.com/solution/industrial_equipment_products/electrical_products_for_mining/power_centers.aspx
ReplyDeleteHi,
ReplyDeleteI 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
Very nicely Explained....Check this site to learn more about Informatica Power Center..
ReplyDeletehttp://tekclasses.in/course/informatica-training/
thanks for shared wonderful information of giving best information.its more useful and more helpful. great doing keep sharing
ReplyDeleteInformatica Training in Chennai
superb.....blog is much interesting which engaged me more.Spend a worthful time.keep updating more.
ReplyDeleteSEO Company in India
SEO Services in India
SEO Companies in India
Great articles, first of all Thanks for writing such lovely Post! Earlier I thought that posts are the only most important thing on any blog. But here a Shout me loud found how important other elements are for your blog.Keep update more posts..
ReplyDeleteDataware Housing Training in Chennai | Hadoop Training in Chennai
Awesome,
ReplyDeleteThank you so much for sharing such an awesome blog...
iphone training classes in bangalore