Interested to Buy Any Domain ? << Click Here >> for more details...
Create a mapping which contains 2 target tables. When the
session runs for the first time it shud load Target table 1
and when it runs for second time it shud load Target
table 2.
- 7 Answers
- 15046 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / babu
Hi,
By using mapping variable,we can achieve this logic.
i.e SRC==>TRANS==>FLT1 ==>TRG1
|==>FLT2==>TRG2
in FLT1 place a condition mod(MVAR,2)=1,in FLT2 place a
condition as mod(MVAR,2)=0
MVAR is nothing but a mapping variable.
I think all are knows how to create,declare and call the
mapping variable.
please concern me if any doughts.
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / babu
Hi Zak,
By default the value of MVAR is 0.The value is
increment by at run time only.
i.e is SETVARIABLE($$MVAR,($$MVAR+1))
Let me know if u have any doughts
mail:
dwarak.vbr@gmail.com
+91-8861145051
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / zak
Hi Babu,
Your logic works fine if you update the MVAR mapping
variable manually before you run the session. Is there a
way to update the MVAR within the mapping??
Thanks for your reply:)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / hai
there is an option to set the value as zero ,with out set
the value manually .
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / triveni munnangi
source_>sq->expression->router->tg1
->tg2
expression:v_count decimal 10 0(variableport) setvariable($$cnt,1)
o_count decimal 10 0 (outputport) $$cnt
router:groups
t1=o_count=0
0_count=1
$$cnt variable integer 10 0 max false
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / perumal
Source -> sq -> sequence Generator -> exp trans -> router
trans -> tgt1/tgt2
create variable nxt_val with next value return from seq gen
and in router give rule as mod(nxt_val,2)<>0 to load tgt1
(since first run value will be 1) and mod(nxt_val,2)=0 to
load tgt2.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / subhajit
Alternative to mapping variable:
Use sequence generator, mod on that and then finally router.
Thanks
| Is This Answer Correct ? | 0 Yes | 2 No |
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What r the type of indexes u generally used in informatica?
guys which is the best institute in banglore to learn informatica??
what is incremantal aggregation?
Scheduling properties,whats the default (sequential)
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
How to recover sessions in concurrent batches?
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.
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
What is Datadriven?
in oracle write query yourname+1 from dual
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
Teradata 
