I have worked on Informatica 7.1.1. I want to know the
answer for the below question.
Target is not created initially.Then how to take the DDL
script from the source and run the Mapping by creating the
Target dynamically?Is it possible by SQL Transformation?
No Answer is Posted For this Question
Be the First to Post Answer
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
What are the new features of the server manager in the informatica 5.0?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
What is update strategy transform?
what is runtime variable?
Explain the types of transformations?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
HOW TO DELETE A RECORD FROM FLAT FILE
What is a candidate key?
What is the meaning of up gradation of repository?