which T/r we can use it mapping parmeter and mapping variable? and which one i

which T/r we can use it mapping parmeter and mapping
variable? and which one is reusable for any mapping mapping
parmeter or mapping varibale?

Question Posted / anil

3 Answers
9098 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any m..

Answer / x

Hi,

All T/R's which we give conditions,their we have an option
of 'variables' here we can use this mapping parameters &
mapping variables mapping parameters are reusable

Is This Answer Correct ?

2 Yes

0 No

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any m..

Answer / bsgsr

i believe it is seq gen, filter, expression in which v can
use mapping parameter and variable.

mapping parameter is reusable. v simply change the value of
the parameter in the parameter fle.

Is This Answer Correct ?

1 Yes

2 No

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any m..

Answer / vijayb

What is T/r..?? is it Transformation..!!
If ur asking about transformation then Lookup Cache (named
and un-named) is a transformation which we can use in a
multiple mapping and also in same mapping in different
lookup.

Is This Answer Correct ?

1 Yes

5 No

Post New Answer

More Informatica Interview Questions

tell me the push down optimization

2 Answers Wipro,

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

1 Answers Puma,

Can we make worklet inside worklet?

1 Answers

How the facts will be loaded? explain

2 Answers HCL,

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers IBM,

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers Cap Gemini,

What are the features of complex mapping?

0 Answers

what is runtime variable?

3 Answers TCS,

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers TCS,

what is the difference between onsite & client site?

1 Answers

For more Informatica Interview Questions Click Here