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?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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
how to load duplicate row in a target
what is the mechanism of the Master-Detail joining condition?
How to generate sequence numbers?
What is the function of aggregator transformation?
If u select groupby port in aggregator what is output and dont select groupby option what is output
What is a design?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
Can u generate reports in Informatica?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
What is update strategy transform?