what is procedure to use mapping variable in source
qualifier transformation? with example
Answer / vemuri vijay
steps
go to source qulifier transformation wtih along with source
and target after that go to the
properties,select user defined join sql editor will open
after that there is two optins on left hand side select
variablel in that there is mapping variables available
Is This Answer Correct ? | 3 Yes | 2 No |
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
Useful UNIX commands regular/frequently used
Can we create two repositories on same database instance in oracle?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
If we are using an aggregator but forget to mention the group by port .what will be the output??
How many transformations can be used in mapplets.
In real time scenario where can we use mapping parameters and variables?
can we see default group,when we use router?if yes how?
Sequence generator, when you move from develoment to production how will you reset
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?