What are the reusable transforamtions?
Answer / krishna
a transformation a repository object...which
receives,modifies and passes the data...reusable
trasfermation is a trasformation where it can be used any
number of time in a mapping or in mapplet.
we can creat a reusable transformation in trasformation
developer or we can creat a normal trasformation in mapping
designer and promot it as a reusable transformation by
changing the properties.
Is This Answer Correct ? | 3 Yes | 1 No |
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are differences between Informatica 7.1 and 6.1
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
Implementation methodology
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
my session have to run Monday to Saturday not run sunday how to sedule in informatica level?
1 Answers Infinite Computer Solutions,
Differnce between filter and router?
How can we get two output ports in un-connect transformation?