Interested to Buy Any Domain ? << Click Here >> for more details...
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
- 2 Answers
- 18218 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anvesh
A variable which is created in workfow manager is called workflow variable. This is used for many tasks, for example.. I created a mapping level variable, which is not assigned with initial value. So by using this Workflow variable we can assign value to the mapping variable.
For this we have to use assignment task.
WF-> Assignment task -> Session(non reusable)
First create a variable in workflow manager, go to workflow-> edit -> add a port. In this assign a name to the variable. Now create assignment task in workflow manager. In this create a new port. Now name it as the name given to mapping level variable and assign a value to this variable.
Now go to session properties -> command, then give $$ mapping variable = $$ Session variable.
this will wrk... if not pls reply me...
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / guest
I used workflow variable to update the session status in
database table.
take assignment task for capturing session status by using
workflow variable if you want in depth pls let me know..
| Is This Answer Correct ? | 4 Yes | 0 No |
What is a router transformation?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
What is a look up function? What is default transformation for the look up function?
What are the performance considerations when working with aggregator transformation?
What is olap (on-line analytical processing?
How You Pull the records on daily basis into your ETL Server.
What is CDC? How to implement CDC?
What is the scenario which compels informatica server to reject files?
What is the maplet?
Mapplets can you use an active transformation in a mapplet,
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
Teradata 
