1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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.

Question Posted / zak

Answers were Sorted based on User's Feedback



Create a mapping which contains 2 target tables. When the session runs for the first time it shud ..

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

Create a mapping which contains 2 target tables. When the session runs for the first time it shud ..

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

Create a mapping which contains 2 target tables. When the session runs for the first time it shud ..

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

Create a mapping which contains 2 target tables. When the session runs for the first time it shud ..

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

Create a mapping which contains 2 target tables. When the session runs for the first time it shud ..

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

Create a mapping which contains 2 target tables. When the session runs for the first time it shud ..

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

Create a mapping which contains 2 target tables. When the session runs for the first time it shud ..

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

Post New Answer

More Informatica Interview Questions

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

lookup transformation with screenshots

0 Answers   TCS,

What are the components of the workflow manager?

0 Answers  

What is workflow? What are the components of workflow manager?

0 Answers  




In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

Differentiate between sessions and batches?

0 Answers  

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,

What is the Difference between DSS & OLTP?

5 Answers  

For more Informatica Interview Questions Click Here
Categories